Telerik Forums
Reporting Forum
2 answers
44 views
Hello,

We recently upgraded the reports to the Q2 2013 release in a project that was previously using Q1 2011. We carried out this update in our local and development environments without issue. However, in the production environment, we experienced some issues that did not come up in our other environments. The reports render fine if they are generated from code and sent to the browser, but, if they are generated using the report viewer control, the report structure renders (fields on the form show up in the correct place, and default values for fields, set in the designer.cs file, render, see screenshot here: http://screencast.com/t/CJKr3kWBntgk) but there is no data being loaded into the form. This persists when we export the report from the report viewer, exporting a report that has no data. This behavior occurs for every report in the system.

I introduced some logging into one of the reports, and reviewed the differences between one that is generated in the report viewer versus one that is generated in the code and output to the browser. There are about 3 times as many entries in the working report as the non working report. At first, I thought the NeedsDataSource event for the report may not be firing, but, it seems to be called in both cases. I've noticed that the detail_itemDataBound event is not getting called, nor are the NeedsDataSource events for my tables in my report. 

I would expect the report to fail in both places, if it was something with the report. It seems like this is environment dependent. There is nothing in the Event Viewer which suggests there is an issue here. Could this be related to our .NET version on our production server (we only have 4.0 on production, while in development we have 4.5.)? Has anyone run into similar issues? Any suggestions?

Thanks,

Travis
Travis
Top achievements
Rank 1
 answered on 05 Sep 2013
3 answers
458 views
i have a requirement of generating the columns dynamically for the telerik reporting table, i.e. i have a client configuration if the clients needs a column to be visible i need to display that as part of report, else that column as well as the space occupeid for that column also should not exist.

so i am dynamically generating columns as part of sql query. I will have several tables as part of the result set and i need to bind all the tables to the report except the first table

i have used the code provied by telerik team for dynamically creating the tables for report, in addition to that i have created a panel class to create panel's dynalically

my code is this:
objDS is my data set
for (int i = 1; i <= objDS.Tables.Count-1; i++)
  
{
  
   string strTableName = "Table" + Convert.ToString(i);
  
   string strPanelName = "Panel" + Convert.ToString(i);
  
   // Creating a dynamic panel for adding the Table.
  
   var panel = MyClass.Panel.CreatePanel(strPanelName);
  
   //creating the dynamic table for each table from the result set                
  
   var table = MyClass.Table.CreateTable(strTableName,
  
     unitType: UnitType.Pixel,
  
     locationX: 1,
  
     locationY: 1,
  
     width: 200,
  
     height: 20,
  
     rowHeight: 20,
  
     dataTable: objDS.Tables[i]);
  
   
  
//Creating the columns dynamically
  
for (int k = 0; k <= objDS.Tables[i].Columns.Count - 1; k++)
  
{
  
     table.WithColumn(objDS.Tables[i].Columns[k].ToString(),objDS.Tables[i].Columns[k].ToString(), 120);
  
   
  
}
  
// Creating the header group and body group data dynamically
  
for (int k = 0; k <= objDS.Tables[i].Columns.Count - 1; k++)
  
{
  
                        table.HeaderTextBoxes[objDS.Tables[i].Columns[k].ToString()].Style.BackgroundColor = Color.YellowGreen;
  
                        table.HeaderTextBoxes[objDS.Tables[i].Columns[k].ToString()].Style.BorderStyle.Default = BorderType.Solid;
  
                        table.BodyTextBoxes[objDS.Tables[i].Columns[k].ToString()].Style.BackgroundColor = Color.Yellow;
  
                        table.BodyTextBoxes[objDS.Tables[i].Columns[k].ToString()].Style.BorderStyle.Default = BorderType.Solid;
  
}
  
//adding the dynamically created table to the dynamically created panel.
  
panel.Items.Add(table);
  
//adding the panel along with table to the static panel created from report designer                 
  
this.reportPanel.Items.Add(panel);

The reason why i am creating dynamic panels is i dont know how many tables i will get as part of result set and i dont dont even know how many columns each table contains i.e. 1st table may have only 5 columns and the Nth table may have 10 columns. And i dont even know the position of the Dynamically created table to place in the report.

after table is generated i am adding the table to the dynamically created panel and all the dynamically created panels i am adding them to the panel which is from Reporting front end.

the code is getting executed perfectly can see the columns created and data binded with no exceptions, but in the report the table is showing this error

"An error has occurred while processing Table 'Table1': Missing operator before 'Required' operand"

no clue about this error, need help on this or if there is some other alrernative approach for my requirement please suggest.

Thanks,
NeelaKrishna

Stef
Telerik team
 answered on 05 Sep 2013
16 answers
2.7K+ views
I have an aspx page with a list of reports.  User clicks one of the report, this opens up a new window to load the report but I have only one report viewer attached on the form.  I want to use code-behind to load the selected report (being passed via URL parameter).  How do I in code behind, load the report using the report viewer control.  There is something about IReportDocument but I'm not sure how to use that to load the report in code behind.

Please show me a sample code, I'm using the latest Q12009 Telerik Reporting.

Thanks,
Kevin

Stef
Telerik team
 answered on 05 Sep 2013
7 answers
320 views
I have skipped a few releases with Reporting.  We have a solution which makes extensive use of textbox formatting based off of the data of each textbox.  This solution was developed in VS 2008 and last Telerik upgrade was to  6.0.12.215.  I have not touched it in months and works great in production.

I have some new reports to make, and have converted the project from VS 2008 to VS 2010, no errors reported.  Also installed Q1 2013 Telerik reporting this morning, no errors in the upgrade process.

Every existing format is now blank for the rule, though the rule still exists.  Every report has dozens of errors on build that all say:

"Type Telerik.Reporting.Data.Filter is not defined"

Format box looks like this, note the left side saying no rule.  There are 20 reports in the solution, each with 1-10 formatting options per textbox, with a few dozen textboxes per report.

Is this a known issue?  Is there a way I can recover all of the formatting work?

Juan Alchourron
Top achievements
Rank 1
 answered on 05 Sep 2013
5 answers
308 views
I'm having quite a few problems styling a Telerik.Reporting.Chart object. The object itself was created using the designer, but the actual information for the chart, such as title, series, etc is filled in at runtime programmatically.

First of all, I was attempting to set the colors for different series in the following manner:
salesSeries.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Gradient;
salesSeries.Appearance.FillStyle.MainColor = Color.White;
salesSeries.Appearance.FillStyle.SecondColor = Color.Black;

But the colors are overridden by the style placed on the chart in the designer. However, if the FillType is set to Solid, I have no problems setting the color.

Second of all, I found this little oddity when trying to set the background color of the entire chart. When setting the background fill as so:
resultChart.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
resultChart.Appearance.FillStyle.MainColor = Color.White;

It ended up using the default background from the skin. However, if I change "Color.White" to "Color.FromArgb(255,255,255)" (still white) it works properly.

Finally, how do you change the font size for the axis labels? My X-axis labels are a little too wide for the text that's in them and I need to shrink the font a little, but I couldn't find any way to do so.
Nasko
Telerik team
 answered on 04 Sep 2013
2 answers
78 views
Hello
  
I am using Telerik Reporting for Silverlight. In the report viewer once the report is generated, I want to print it by clicking on the "print" icon in the menu bar on top of the report.
  
After clicking on that button the popup showing the progress for the print generation is displayed as expected. Both "print" and "cancel" work fine in most cases. However, when a report is "big" (here I have a 38 pages report as per the report viewer or enough data in the report to generate a 2MB PDF file if it helps), the increment of the percent in that same popup does not start right away. If I click on the "Cancel" button before the percents start to increase, the popup does not close as it would otherwise. The "cancel" button becomes greyed out and the printing process keeps going until it reaches 100%. Once the process is over, there is no choice but to print the report (the "print" button is no more greyed out) or close the whole report viewer as the "Cancel" button remains greyed out.
  
We are using Silverlight 4 and the version of Telerik reporting we are using is the 6.0.12.215. Let me know if you need more information for your investigation.
Guillaume
Top achievements
Rank 1
 answered on 04 Sep 2013
2 answers
444 views
Hello,

I would like to know if the following is possible.  I would like to have a report where the page orientation is portrait for most pages, but some are set to landscape. 

I have tried the following:
I have a main report with the PagSettings.Landscape property to false.  I also have a subreport that is in a section with page breaks to make it on it's own page. For the sub report I set the PagSettings.Landscape property to true. When I run the report in the WinForms report viewer it seems that the page orientation setting from the main report is used and the orientation on the sub report is ignored.  Is this true?  Is there any work around to get one page of a report to be landscape while the rest of the report is portrait?  FYI, I'm using the WinForms viewer for development but the final product will export the report directly to PDF.

Thanks,

Chris
Marshall Long
Top achievements
Rank 1
 answered on 03 Sep 2013
10 answers
231 views
Hello,

I am using the new Q3 2012 controls and the Telerik Silverlight ReportViewer is giving me an error... "Unable to determine application identity of the caller". How can I resolve this?


Cheers
Stef
Telerik team
 answered on 03 Sep 2013
3 answers
104 views
I have a Web Application that populates various controls that are used as parameters, i.e., 3 RadDropDownTrees, 4 RadComboBoxes with check boxes, and RadComboBox without check boxes.
I know I can use the data sources that populate the combo boxes, but I do not know if I can use the datasources for the RadDropDownTrees.

My question is can a RadDropDownTree be used as a parameter in reportViewer? And if so, how?
Stef
Telerik team
 answered on 03 Sep 2013
1 answer
166 views
Hi,

I have an MVC application and pass ViewModels to the Object Data Source for my reports. All reports i've written are tabular, nothing complex. I now need to display a pie chart on my report.

Can I still use a view model for the data source? I've not found any examples anywhere of using pie charts this way, is it possible?

Thanks.
Squall
Top achievements
Rank 1
 answered on 03 Sep 2013
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?