What is the recommended way to access properties and methods on a report class from a report viewer?
For example:
MyReportBase : Telerik.Reporting.Report
public string ReportTitle
public string GetNumberOfRecords()
MyReportClass : MyReportBase
Form MyReportViewer has a radReportViewer control on it.
Suppose I want my form to set it's title to be myReport.ReportTitle + " - " + myReport.GetNumberOfRecords() + "records"
eg Client List - 127 records
The radReportViewer control is using the InstanceReportSource type for the report source.
I am trying to print Telerik report (.trdx) directly to the printer using MVC.
Please let me know the solution.
I get error message in html5 report viewer "Internal Server Error: undefined" after I update my project to .Net Framework 4.5.2 and update Microsoft.AspNet.WebApi to version 5.2.3.
Now I'm using Telerik reporting Q3 2014 8.2.14.1027
Hello!
I'm currently upgrading Telerik reporting in my application from version 5.1.11.928 to version 8.2.14.1204. I am using Visual Studio 2010, using C#.
I'm encountering a problem with a report parameter using a sqlDataSource. At first, I was encountering a problem because an arraylist was being used in a parameter (as an ansistring). This caused an error with XML serialization. So I realized that an arraylist wouldn't work anymore. However, the query its using is relying on accepting a collection of values.
(e.g. (Where number.ID IN (@ValueType) )
I saw that I can change the parameter to accept multiple values from:
http://www.telerik.com/help/reporting/designing-reports-parameters.html
However, I can't seem to get it to work correctly. For some extra context I have also changed the collection to a hashset<int>.
The report parameters are being set with code that uses the reportviewer.
Example:
var genericReport = new GenericReport();
genericReport.ReportParameters["ValueType"].Value = hashValueGenerator("Selector");
//hashValueGenerator returns a hashset of integers based upon its selector
//This used to be an arrayListGenerator
From there, the code would then take the report that was generated and add it to the reportSource. (This part works fine.)
I believe I am setting up my value type incorrectly to accept the new collection I'm creating.
Here is the parameter as it existed before the upgrade:
Name: @ValueType
DbType: AnsiString
Value: =Parameters.ValueType.Value
This is my attempted fix to my problem:
Name: @ValueType
DbType: Int32
Value: //Shown below as created in the Report Parameter Editor
//Only the bolded (non-default) changes are being displayed
//Organized to look like pseudocode, but I am using the editor
//Quotes are for readability, they are not used in the actual editor boxes
Report Parameter{
AvailableValues {
DataSource = sqlDataSource,
//The same as shown as the data source on the report designer.
ValueMember= "=Parameters.ValueType.Value"}
MultiValue= true,
Name= ValueType,
Text= ValueType,
Type= Integer,
Visible= true
}
I get the following error in my Report Viewer: "Missing or invalid parameter value. Please input valid data for all parameters."
Can anyone give me any insight as to what I'm doing wrong?
Thank you very much!
I have a report which I view via a ReportViewer on a web page. In the viewer, I can choose to export to CVS. In the resulting CVS file, the headers do not show the names of the header textboxes like I want them to. Instead, they show the default names that were given to the textboxs when the report was created.
For instance, initially a header textbox was named "prodOrderDataTextBox" automatically. In the properties of the textbox, I renamed it to "ProdOrder" and it is this name that I want to appear in the CVS file.
How can I change this?
<
my:ReportViewer
x:Name
=
"ReportViewer1"
Width
=
"1000"
ReportServiceUri
=
"../ReportService.svc"
Report
=
"ReportsLib.Report1,ReportsLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
>
</
my:ReportViewer
>
# Result Protocol Host URL Body Caching Content-Type Process Comments Custom
162 500 HTTPS localhost:1807 /ReportService.svc 834 private text/xml; charset=utf-8 iexplore:5752
163 500 HTTPS localhost:1807 /ReportService.svc 1,116 private text/xml; charset=utf-8 iexplore:5752
164 500 HTTPS localhost:1807 /ReportService.svc 1,332 private text/xml; charset=utf-8 iexplore:5752
165 200 HTTP localhost:1807 /ReportService.svc/resources/getrenderstream?instanceID=c07b6ca8-bd44-48cd-8e2f-56718e3e5283&name=5a214af8d59c4e86ad6b023d69ea4307 25,661 private image/png iexplore:5752
<
my:ReportViewer
x:Name
=
"ReportViewer1"
Width
=
"1000"
ReportServiceUri
=
"../ReportService.svc"
Report
=
"ReportsLib.Report1,ReportsLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
>
</
my:ReportViewer
>
Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
------------- InnerException: -------------
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
at proxy_6.EndListRenderingExtensions(IAsyncResult )
at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndListRenderingExtensions(IAsyncResult result)
at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<
EndGetResponse
>b__9(Object sendState)
at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<
BeginOnUI
>b__0(Object sendState)
# Result Protocol Host URL Body Caching Content-Type Process Comments Custom
262 500 HTTPS unowos /demo/ReportService.svc
263 500 HTTPS unowos /demo/ReportService.svc
264 500 HTTPS unowos /demo/ReportService.svc
I want to create a report with a specific layout based on a given model, but the dataset it will be based on will be dynamically created via the (application) UI.
I'd rather do this and supply a populated model to the report than to have a report will a gazillion parameters that are populated by the app and then have the report fetch the data all over again.
Q: Can I do this?
Q: If I can can some one give me an example (Pretty Please)
Q: Can I do this using TRDX files?
Q: Can I do this using *.cs reports?
Q: Can I be really pushy and as for examples of both (Pretty Please with Sugar on).
Hi All,
I have a report where I use the toggle visibility action on a certain table group. I have the group visibility set to 'false' so it is collapsed when I run the report. I can click the '+' button and the details expand.
There is another function that I want on this report that I cannot figure out. I also want the same detail section from above to be able to 'ShowAll' details based on a parameter. The user can click true on this parameter which would override the toggle visibility action and show all details in the fully expanded form.
The reason for this is so that if a user wants to see all details, they don't have to go down the list and click every '+' to expand the collapsed sections.
I have attached a screenshot of a sample report where I need this functionality.
Thanks,
Phillip
hi!
I have managed to setup a self-hosted Reporting REST WebAPI server. Now I would like my WPF application to consume a report using that API. Is there a way i XAML to set the reportSource to the WebAPI?
<tr:ReportViewer Margin="10" Height="400" ZoomMode="PageWidth">
<tr:ReportViewer.ReportSource>
<trReporting:UriReportSource Uri="Reports\StatusReport.trdx"/>
</tr:ReportViewer.ReportSource>
</tr:ReportViewer>
How can I let the server generate the report and pass it to my application? This would help a lot since I don't want the users of the application to have direct permissions on the database where the report fetches all the data.
All help is appreciated!