Using the WCF designer with stored procedures with parameter

[flip]

Hi,

could you please explain me how to use a stored procedure in the reports designer with parameters.
I am using the WCF designer to render the report on the server side.
I can succesfully retrieve the stored procedure in the add datasource window, and can add my parameters to it.
Now I don't know how to fill the parameters on the server side, when rendering the report.
Doe you have a tutorial on how to achieve this?
I searched the forums, but could not find a solution.

Thanks!

[Alex K.]

Hello,

You can use the following code:

Code: Select all

report.Dictionary.DataSources["DataSourceName"].Parameters["ParameterName"].Value = YourValue;

or for compiled report:

Code: Select all

report["ParameterName"] = YourValue;

Thank you.