Creating reports and dashboards | Stimulsoft community forum

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.

Hello,

Please check attached project.

Thank you.

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.

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.