Procedure to pass parameters

[AbdulAleem]

Can you please describe the method for displaying the report by passing parameters with query embedded in the report,Right now I am able to show report ising Report.regdata().

This is very urgent.

Thanks.

[Jan]

Hello,

Please check attached project.

Thank you.

[AbdulAleem]

Hi

Can you please tell how to add parameter to report.I want to create report by creating a embedded parameter query in report.

and also please tell how to pass parameter through c# to the report file.

The download provided in the last reply do not contain a .mrt file.

It is urgent.

I could add a query but when I am clicking retrieve columns it is giving error saying create a scalar variable @parametername.

Query : select t.* from tablename t where t.field = @parametername

Thanks.

[Edward]

Hi

The code for passing of the parameters into the report is the following:

report.Compile();
report["@parametername"] = myparametervalue;

Please see also the following:

Here the links on how to use named and unnamed parameters:

Named parameters:
http://www.stimulsoft.com/livedemos/Rep ... eters.html

Unnamed parameters:
http://www.stimulsoft.com/livedemos/Rep ... ers_2.html

If none of above worked, then workaround is here:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=504

Also please open Demo.exe sample application from the standard installation of Stimulsoft Reports.Net.

Open 'SQL' category and the report Master-Detail with Parameters. Press 'Design' button. It is also an example of using parameters.

And in C:\Program Files\Stimulsoft Reports.Net 2009.2 Trial\Samples\C#\SqlParameters\ you can find a project which describes work with parameters in Stimulsoft Reports.Net.

Thank you.