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

[m.issa]

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

[Alex K.]

Hello,

Please try to use the following code:

Code: Select all

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

Thank you.

[m.issa]

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

[Alex K.]

Hello,

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