Report VS ReportSource

[james]

I want to set the DataSource parameters at Webforms runtime so I created a DataSource with the code below. Hos do I attached this to the report before setting the ReportViewer reportSource? I can create a Report object and set the DataSource but how do I assign it to the reportsource which is set to the viewer?

 

 Telerik.Reporting.SqlDataSource sqlDataSource = new Telerik.Reporting.SqlDataSource();
                sqlDataSource.SelectCommand = "SELECT * FROM VerifiedComponents WHERE ItemNumber = @ItemNumber";
                sqlDataSource.Parameters.Add("@ItemNumber", System.Data.DbType.String, "14545454545");         

 

  Telerik.ReportViewer.Html5.WebForms.ReportSource reportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
                reportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource;
                reportSource.Identifier = typeof(Report1).AssemblyQualifiedName;             

              reportViewer1.ReportSource = reportSource;     

[Todor]

Hi James,

When you assign a DataSource to the report you modify the report definition. This can be done only server-side, in a Custom ReportSource Resolver. You need to instantiate the report in the Resolve() method, and after changing the report definition instance to wrap it in an InstanceReportSource and return it to the Reporting engine.

On the client-side, in the Html5 Report Viewer, you need to use IdentifierType CustomReportSource. The Identifier that you set in the viewer's ReportSource is the string reportId that you receive in the Resolve() method of the resolver. You need to use it to identify the report that will be rendered.

Regards,
Todor
Progress Telerik

[james]

Hi Todor,

Thanks for the reply. Basically I was just trying to set the SqlDataSource parameter with code and couldn't find the interface to do that. But I figured out how to tie the Report parameter to the SqlDataSource parameter in the designer so I got what I needed.