Change report parameters dynamically

[dilip]

Hi,

We are evaluating Telerik Reporting control but are facing problems in creating report pages. The problem is as follows:
We want to create a report whose data comes from stored procedure in database. The sp has 2 parameters which changes based on the drop-down controls on the report page. Now we have developed an report.aspx page and put a ReportViewer control in that page. Then we had created a Telerik Report using designer and then added this report to the ReportViewer control in report.aspx page.
Now where do we specify the parameters for the report? And then how do we bind the data after changing parameters?

The report is very similar to http://demos.telerik.com/reporting/employee-sales-summary/demo.aspx But on the demo page video is not available. Please let us know how to build such kind of reports. We have already spent lot of time in doing own. Your reponse will help us in making a decision to buy the product.

Thanks,
Dilip

[Steve]

Hi Dilip,

The following links:

• Video Using Stored Procedures in Telerik Reporting with the SqlDataSource Component
• Help article Using Parameters with the SqlDataSource component
• Help article How to: Connect to a SQL Server Database Using Stored Procedure

elaborate on your inquiry and shows how to wire up the DataSourceParameter Class to ReportParameter Class.
The Employee Sales Summary report does not have a video is because we added this report in the last release and we are currently working on creating a video for it. It should be available shortly (probably by the end of next week)

All the best,
Steve
the Telerik team