Telerik Forums
Reporting Forum
3 answers
133 views
Hi, I have recently upgraded from a very old version of Reporting to the latest, and I am having some issues.

My reports will render the headers etc but no rows are returned.  I have a class library project defining the reports, used in a VB web site.

So I have a development environment and it was showing no rows, I ran a trace and saw it issuing FMTONLY in the queries.  I googled that for hours and found lots of references to the use of temp tables in stored procedures in your report data sources.  but my TableAdapters do not use stored procs at all. They use sql views, and have select queries in the Adapters.

So I tweaked this and that until it got to be very late at night and then finally, at some point, it started to work!  It now issues correct queries and returns rows of data.

So I deployed it to my production environment... and now it has the no-rows problem.

I don't know what finally fixed the problem.  

I suspect it was a SQL Server setting as I have confirmed that the code running in both environments is the same.
don
Top achievements
Rank 1
 answered on 19 Apr 2012
3 answers
189 views
I have a problem with Reporting since I upgraded to 2012Q1.
In the designer I see my chart correct, but in the browser it shows the chart's plotarea expanded and clipped.
Also the chart looks like it is zoomed-in
See attached pictures to see what I mean.
Can anyone tell me what to do to get the size of the chart correct?
Regards
Frank
Steve
Telerik team
 answered on 19 Apr 2012
1 answer
147 views
Hello,

I think i have this mostly figured out but im getting errors. Im getting trouble at this line: labelItem1.TextBlock.Text = procChart.Report.Parameters["Due Beyond"].Value.ToString;...My understanding of C# is limited so i dont see where im going wrong. Can you help me figure this out?

namespace Reports
{
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;


    /// <summary>
    /// Summary description for DeliveryStatus___Client.
    /// </summary>
    public partial class DeliveryStatus___Client : Telerik.Reporting.Report
    {
        public DeliveryStatus___Client()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();}


            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        private void chart1_ItemDataBinding(object sender, EventArgs e)
{
            var procChart = ((Telerik.Reporting.Processing.Chart)sender);


            Telerik.Reporting.Charting.LabelItem labelItem1 = new Telerik.Reporting.Charting.LabelItem();
            Telerik.Reporting.Charting.LabelItem labelItem2 = new Telerik.Reporting.Charting.LabelItem();
 
                labelItem1.Marker.Visible = true;
                labelItem1.Name = "LegendItem1";
                labelItem1.TextBlock.Text = procChart.Report.Parameters["Due Beyond"].Value.ToString;
                labelItem2.Marker.Visible = true;
                labelItem2.Name = "LegendItem2";
                labelItem2.TextBlock.Text = procChart.Report.Parameters["Due Monday"].Value.ToString;
                this.chart1.Legend.Items.AddRange(new Telerik.Reporting.Charting.LabelItem[] {
                labelItem1,
                labelItem2});
            this.chart1.Legend.Items.AddRange(new Telerik.Reporting.Charting.LabelItem[] {labelItem1,});
}




            






   
}
        }
}


    
Steve
Telerik team
 answered on 19 Apr 2012
4 answers
149 views
Hi,

I am using Telerik Reporting v5.3 trial version. After I built a report, I displayed it in the Silverlight ReportViewer control, however, I found no way to print my report because the print button in the ReportViewer toolbar is always gray. And neither is there a Print Preview button available. Is this because I am using the trial version?

Thanks a lot!

Xinfeng
Xinfeng
Top achievements
Rank 1
 answered on 19 Apr 2012
2 answers
634 views
Hello All,

I am using Telerik Reporting Control.
I want to  make all Reporting Filters as optional.

The filter can be DateTime / String / Bool / Integer or anything else.
After browsing few of the forums i Set AllowBlank and AllowNull properties to True for all filters.
(I know the AllowBlank = True is only valid in case of String Type.. But still i Set it for all types for testing)

But still it is not giving the desired results.

What i want exactly is to show All Report Data by default if no filter value has been assigned.
It works fine if there is only String type filters are provided. But if i add DateTime Filter (DateTime or Nullable DateTime)
it won't show the results..
Is it possible to show unfiltered Data on report ???

I also Set the Default Value to Null but still no results.

Can anybody help..

Thanks in Advance
Kailash
Top achievements
Rank 1
 answered on 19 Apr 2012
1 answer
127 views
Im trying to adjust the labels on the legend of a pie chart and want to make sure i have the need data source event set up correctly, does it look correct below? sorry about the code format below i dont know how to condense of format it as asked.

namespace

 

 

Reports

 

{

 

 

using System;

 

 

 

using System.ComponentModel;

 

 

 

using System.Drawing;

 

 

 

using System.Windows.Forms;

 

 

 

using Telerik.Reporting;

 

 

 

using Telerik.Reporting.Drawing;

 

 

 

using Telerik.Reporting.Charting;

 

 

 

/// <summary>

 

 

 

/// Summary description for DeliveryStatus___Client.

 

 

 

/// </summary>

 

 

 

public partial class DeliveryStatus___Client : Telerik.Reporting.Report

 

{

 

 

public DeliveryStatus___Client()

 

{

 

 

//

 

 

 

// Required for telerik Reporting designer support

 

 

 

//

 

InitializeComponent();

}

 

 

//

 

 

 

// TODO: Add any constructor code after InitializeComponent call

 

 

 

//

 

 

 

 

private void chart1_NeedDataSource(object sender, System.EventArgs e)

 

{

Telerik.Reporting.Processing.

 

Chart chart = sender as Telerik.Reporting.Processing.Chart;

 

chart.Series.Clear();

 

 

ChartSeries s = new ChartSeries();

 

s.Type =

 

ChartSeriesType.Pie;

 

s.Appearance.LegendDisplayMode =

 

ChartSeriesLegendDisplayMode.ItemLabels;

 

chart.Series.Add(s);

}

}

}

Steve
Telerik team
 answered on 19 Apr 2012
3 answers
441 views
Related to: http://www.telerik.com/community/forums/reporting/telerik-reporting/getting-uncaught-syntaxerror-unexpected-token-when-using-asp-net-mvc3.aspx 

I'm also seeing the same issue, except it's stopping our users from printing reports. When they click the print icon, they'll see the message "Unable to perform the Print operation". The only way for them to print, is to export to PDF and then print from that app.

I notice that you said a fix was available, but that it's not available - any suggestions?

-- Kori
Steve
Telerik team
 answered on 19 Apr 2012
3 answers
110 views

Hello, Im new to coding in general and am trying to label the columns in a chart.  I have the chart displaying the data i want, but all the labels are 1,2,3, etc.  for each column. I tried using the code below but without much coding experience im not sure how to use it. I think i need something before it to make it work but im not sure.  Im also not sure where in the code this should go, does it go in the general .cs file for Telerik Reporting Item or does it go in the "details" section where the chart is located? if i can provide any more info please ask.

Chart.PlotArea.XAxis.AutoScale = false;
Chart.PlotArea.XAxis.AddRange(1, 7, 1); 
Chart.PlotArea.XAxis[0].TextBlock.Text = "Mon";
Chart.PlotArea.XAxis[1].TextBlock.Text = "Tue";
Chart.PlotArea.XAxis[2].TextBlock.Text = "Wed";
Chart.PlotArea.XAxis[3].TextBlock.Text = "Thu";
Chart.PlotArea.XAxis[4].TextBlock.Text = "Fri";
Chart.PlotArea.XAxis[5].TextBlock.Text = "Sat";
Chart.PlotArea.XAxis[6].TextBlock.Text = "Sun";
Steve
Telerik team
 answered on 19 Apr 2012
2 answers
149 views
Hi,

I'm facing a little problem. I've updated my telerik's DLLs today (ASP.NET AJAX & Reporting).
Everything is working but the reporting part. Actually when i run my project, the ReportViewer works fine and i can see it beeing filled, but in visual studio i still have a warning on my tag : "Element 'ReportViewer' is a not known element.".
What's wrong with VS2010?
I let you see samples of my web.config :
<system.web>
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Speech, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="Telerik.ReportViewer.WebForms, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
        <add assembly="Telerik.Reporting, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
      </assemblies>
    </compilation>
 
...
 
<pages>
    <controls>
      <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI" />
      <add tagPrefix="tlkReporting" namespace="Telerik.ReportViewer.WebForms" assembly="Telerik.ReportViewer.WebForms"/>
    </controls>
And there is my .aspx tag :
<tlkReporting:ReportViewer ID="ReportViewer1" runat="server" Height="500px" Width="100%" Visible="False" />
I don't understand what's going on :/
If anyone could help me it would be great, thanks in advance
Julien
Top achievements
Rank 1
 answered on 18 Apr 2012
1 answer
74 views
Im working with a bar chart in VS 2010 with Telerik reporting Q3 2011, Is it possible to reposition the Datagroupcolumn to appear outside the chart area? or can it be moved to the corner of the chart somewhere? if neither can be done is there a way to make it not appear and assign the labels given to each bar of data? Ive attached a screenshot to show what i am talking about.
Steve
Telerik team
 answered on 18 Apr 2012
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?