Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Sep 04, 2012 9:31 am**

Hello all

i am using demo version
i am trying to pass parameter from C# code into my report sql parameter
i declared the parameter in the query in the report , this is my query in my stimulsoft report:

SELECT *
FROM ViewEmpDep
WHERE ViewEmpDep.CatID = {param1}

and i declared the veriable for that parameter in my report.

In the C# this is my code:

StiReport report = new StiReport();
report.LoadFromString(a);
report.Render();
report["param1"] = 2;

i am using fx viewer, the report display but with no result alghouth i pass (2) to the report and there are results for this number in my data base .

is that becuase i am using demo version or there is another reason?

thanks

Posted: **Wed Sep 05, 2012 7:59 am**

Hello,

Please try to use the following code:

Code: Select all

report.LoadFromString(a);
report.Compile();
report["param1"] = 2;
report.Render();

Thank you.

Posted: **Wed Sep 05, 2012 11:06 am**

Hello Aleksey

your Code solved my problem:

report["param1"] = 2;
report.Render();

so i did not write report.Render(), now every thing fine after i added this line.

thanks a lot

Posted: **Thu Sep 06, 2012 6:44 am**

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Creating reports and dashboards | Stimulsoft community forum

can i pass Parameter into SQL base Report in demo version?

can i pass Parameter into SQL base Report in demo version?

Re: can i pass Parameter into SQL base Report in demo versio

Re: can i pass Parameter into SQL base Report in demo versio

Re: can i pass Parameter into SQL base Report in demo versio