Telerik Forums
Reporting Forum
2 answers
349 views
Is there a way to control the number of rows per page so i wont have the scrolling?  Thanks.
ethan
Top achievements
Rank 1
 answered on 22 Mar 2011
3 answers
141 views
Hi,

I am looking to integrade your reports for Silverlight into my application. I wend through all your examples and they have one thing in common, all reports are binded to datasource permanently and you can only send parameters from within ReportViewer component.  Here what I need:

1. Before opening report on the client side, I need to send some parameters to the server.  Based on these parameters, I will generate a set of data objects (i.e. IEnumerable or other collectable object) and bind it to the report, so that only this data is returned to the client side.  How do I achiev this?
1.a. Alternatively, if I could return only the report template to the client and separately I could get a list of data objects from the service.  Then bind it to the Report Viewer on the client side.
2. How do I protect my service from illigal use?  Here is a simple example.  If I want to call some method from the service, one of my parameters can be a password.  When service receives a call, I evaluate that parameter, if it matches the password, I return the result.  This prevents someone designing a silverlight program which connects to my service without know this password.  How does it work with your reports?  What stops someone creating a silverlight application with your ReportViewer, connect to my service and retrieve all data?
Peter
Telerik team
 answered on 22 Mar 2011
0 answers
113 views
Hi,

I have a report in an ASP.NET website that uses an SqlDatasource with stored procedure to get the data I require.
I create a pdf from the report on runtime, and what I'm trying to do is change the connectionstring on runtime.
I know I can add code to the constructor to get the connectionstring from the web.config, but this requires a fixed connectionstring name, and I don't want this.
I also know the Datasource is accessible, but I don't want to set the datasource, just the connectionstring
So what I'm looking for is a way to pass the connectionstring to the report somehow.
As a parameter won't work, however, since the parameters aren't set yet when the constructor is called.

Any ideas?

CJ
AnneArents
Top achievements
Rank 1
 asked on 22 Mar 2011
1 answer
204 views
This is more of a theoretical question. Let's say I have a report generated that contains some information and a pie chart. The user viewing the report decides they would rather view the information in a bar graph. Is there a way to change the pie chart into a bar graph (or any other chart type) dynamically in the report while the user is viewing it?

Thanks in advance!
Massimiliano Bassili
Top achievements
Rank 1
 answered on 22 Mar 2011
0 answers
42 views
Follow JC and OpenAccess and implement WCF Dialog boxes

1) Allow us to use arrow keys in the input boxes
2) Some way to specify\handle null on the row w\out needing IsNull every time
sitefinitysteve
Top achievements
Rank 2
Iron
Veteran
 asked on 21 Mar 2011
2 answers
195 views
HI
I am trying to create a WPF application and want to use data reports
I have added all the references as mentioned in http://www.telerik.com/help/reporting/wpf-report-viewer-embedding-the-viewer.html
I can see report viewer control on the window after draging it onto it
But when i build my application i get the below error

Error 7 The tag 'ReportViewer' does not exist in XML namespace 'clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf'. Line 7 Position 10. C:\Users\Nilesh\Documents\Visual Studio 2010\Projects\Impulse1\Impulse1\rep_window.xaml 7 10 Impulse1

Also I can see certain warnings

Warning 1 The referenced assembly "Telerik.Reporting, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1

Warning 2 The referenced assembly "Telerik.ReportViewer.Wpf, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1

Warning 3 The referenced assembly "Telerik.Reporting.XamlRendering, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1

Warning 4 The referenced assembly "Telerik.Reporting, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1

Warning 5 The referenced assembly "Telerik.ReportViewer.Wpf, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1

Warning 6 The referenced assembly "Telerik.Reporting.XamlRendering, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project. Impulse1




Please assist me
I am using Visual Studio 2010 .net Framework 4 
veena
Top achievements
Rank 1
 answered on 21 Mar 2011
0 answers
109 views
Currently we used CrystalReport as out embedded reporting tool.  When the customer needs a custom report, we will build it and send the rpt file to them, which they drop it in a folder and the application will pick it up automatically, without the need to recompile the application.

Is this possible with Telerik Reporting?
Edward
Top achievements
Rank 1
 asked on 21 Mar 2011
2 answers
146 views
Hello. We are using a Silverlight ReportViewer to call into a class library that contains a report definition. 90% of the time our report comes up fine. But the other 10% of the time, we get the message:
"One or more parameters are not set or have invalid values"
in the report that pops up.

I am calling the report the same way every time, so that leads me to believe there is some kind of timing issue. [EDIT: When this happens, I see the report briefly flash on the screen. Then I get the message about the invalid values. At that point, if I click the refresh button the report viewer, the report comes up fine. It comes up very fast. So, it's not like it's rendering the report when I click the refresh button.]

I was hoping Telerik could see something that we are doing wrong that may be causing this timing issue. Again, we are calling the report with the same parameters, so it's not like we're leaving out a parameter.

In our XAML, we have a ReportViewer control. In the RenderBegin event of the ReportViewer, we are doing this (leaving out a lot of parameters for clarity - also taking out names that identity our business model):

object[] param1 = new object[MyCollection.Count];
object[] param2 = new object[MyCollection.Count];
int loopCounter = 0;
foreach (Widget myWidget in MyCollection)
{
   param1[loopCounter] = myWidget.param1;
   param2[loopCounter] = myWidget.param2;
   loopCounter++;
}
args.ParameterValues["Param1"] = param1;
args.ParameterValues["Param2"] = param2;

In the NeedDataSource event of the report, we are doing this. (ReportItem is a class I defined.)

Telerik.Reporting.Processing.Report myReport = (Telerik.Reporting.Processing.Report)sender;
System.Collections.Generic.List<ReportItem> reportItems = new System.Collections.Generic.List<ReportItem>();
object[] param1Array = (object[])myReport.Parameters["Param1"].Value;
object[] param2Array = (object[])myReport.Parameters["Param2"].Value;
for (int loopCounter = 0; loopCounter < param1Array.Length; loopCounter++)
{
   ReportItem ri = new ReportItem();
   ri.param1 = param1Array[loopCounter].ToString();
   ri.param2 = param2Array[loopCounter].ToString();
}
this.DataSource = reportItems;

Not sure if this matters or not, but we are displaying the ReportViewer in a ChildWindow. In the code-behind of the XAML of the child  window, we are doing this:

public ShowMyReport()
{
    InitializeComponent();
}
private void ChildWindow_Loaded(object sender, RoutedEventArgs e)
{
    MyViewModel vm = (MyViewModel)this.DataContext;
    vm.RefreshReport += new System.Action(vm_RefreshReport);
    ReportViewer1.RenderBegin += vm.OnBlahRenderBeginCommand; // This points to the RenderBegin event I talked about above
    vm.UpdateReport();
}
void vm_RefreshReport()
{
    ((ReportViewerModel)this.ReportViewer1.DataContext).RefreshReportCommand.Execute(null);
}

Thanks.


john doe
Top achievements
Rank 1
 answered on 19 Mar 2011
4 answers
645 views
Hi,

We are using Q3 SP1 Reports in a Web Report, and have a single group footer section where we have tried using PageBreak=After as well as PageBreak=Before. Either way, we get page page of report data as expected, followed by a blank page, then repeat x the 300 pages that are in this report. We have looked and there are no other, duplicate PageBreak statements that would cause this. We just have a simple pageheader, detail section, a groupfooter where we are setting the pagebreak, and a pageFooter section.

Any help appreciated.

Nathaniel
Top achievements
Rank 1
 answered on 18 Mar 2011
1 answer
127 views
Hi

I have previously created a thread about this problem. When rendering my reports and the amount of rows are less than +/- 2000 rows the report renders without problem. When the rows are 2000+ the report sometimes render right and sometimes it throws the dreadful "An exception occurred during the operation, making the result invalid.  Check InnerException for exception details." exception.

One of the telerik members recommend that I look at the output window in visual studio while in debug mode. But no error appears and the only messages that appear is the following:

*** ReportProcessor.Render STARTED ***
  
*** ReportProcessor.GetRenderer STARTED ***
*** ReportProcessor.GetRenderer DONE in 00:00:00.0000277 ***
  
  
*** ProcessReport #0 STARTED ***
The thread '<No Name>' (0x25ac) has exited with code 0 (0x0).
The thread '<No Name>' (0x1a90) has exited with code 0 (0x0).
The thread '<No Name>' (0x1534) has exited with code 0 (0x0).
  
*** Report Processing STARTED ***
*** Report Processing DONE in 00:00:00.3108771 ***
  
  
*** Measure Report (Horizontal) STARTED ***
*** Measure Report (Horizontal) DONE in 00:00:00.0361700 ***
  
  
*** Measure Report (Vertical) STARTED ***
*** Measure Report (Vertical) DONE in 00:00:00.4248685 ***
  
*** ProcessReport #0 DONE in 00:00:58.5183698 ***
  
  
*** RenderReport #0 STARTED ***
'iexplore.exe' (Silverlight): Loaded 'C:\Program Files\Microsoft Silverlight\4.0.50826.0\en-US\System.ServiceModel.debug.resources.dll'
*** RenderReport #0 DONE in 00:00:13.2401077 ***
  
*** ReportProcessor.Render DONE in 00:01:12.1509348 ***
  
The thread '<No Name>' (0xc08) has exited with code 0 (0x0).

According to the messages the rendering was successful but in the UI the "An exception occurred" error appears.

This is becoming a critical problem as our clients are getting very irritated.

Please, please help us. We must resolve this no matter what. Either we must establish that Telerik can handle large data in their Silverlight reportViewer and the problem lies somewhere else or we must establish that Telerik can not handle this kind of quantities and we must discard Telerik reporting and use another tool.
Peter
Telerik team
 answered on 18 Mar 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?