How to load a prebuilt report with parameters in C#?

[Brandon]

Not sure if I'm doing this right.  I've been trying out various reporting tools for a pretty big project I'm starting.

I was able to design a report in the designer standalone the way I wanted it.  So now in C# I want to load that report using a parameter for the queries.

I assume I set the reportviewer reportsource property and then create the parameters.  I just can't seem to get it to work.  Says my connection string isn't right though I set that at design time and it works fine in the standalone designer.

Maybe I'm doing this all wrong?

[Brandon]

Well I can't edit the first post but I figured out my problem for the connection string not working..

So I'm past the unable to connect problem, but still unsure 

A) how to pass parameters into the reportviewer source. 

B) if I'm doing this correctly.

[Brandon]

OK figured it out.  I set up the parameters in the data sources themselves, but not the report.

Had to assign the datasource params to the report param..  It's working now.

[Stef]

Hi Brandon,

If you need to use a data retrieval method with parameter, the parameters should be mapped to report parameters. Consider the examples in the following articles:

• Using Parameters with the SqlDataSource component;
• SqlDataSource Wizard - step by step illustrations how to configure a data source component, when parameters are involved;
• Using Parameterized Queries in Telerik Reporting with the SqlDataSource Component - video tutorial;

When you display the report, report parameters values can be passed through the used Report Source object - the ReportSource.Parameters collection (key-value pairs) is mapped to the Report.ReportParameters collection by key.
​
Regards,
Stef
Telerik