Page 1 of 1

Using the WCF designer with stored procedures with parameter

Posted: Fri Dec 28, 2012 8:54 am
by 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!

Re: Using the WCF designer with stored procedures with param

Posted: Sat Dec 29, 2012 7:36 am
by 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.