Pass a value to Stimulsoft report parameter

Question

0.00/5 (No votes)

See more:

Hi
I have a report in windows form application that it's designed by Stimulsoft report generator. My report get data from MySQL database by a stored procedure.
My stored procedure has a parameter as PersonalCode and my report has a parameter with same name.
I want load report file and pass a value to this parameter.
I use from some solutions that are listed in bellow, but all of them is not correct:

First Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load("mrt file path");
report.Compile();
report.Variables["PersonalCode"] = 932;
report.Render();
report.Show();

Second Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load("mrt file path");
report["PersonalCode"] = 932;
report.Show();

Third Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load("mrt file path");
report.Compile();
Stimulsoft.Report.Dictionary.StiDataParameter parameter = new Stimulsoft.Report.Dictionary.StiDataParameter();
parameter.Name = "PersonalCode";
parameter.Value = "932";
report.DataSources["PersonalInformation"].Parameters["PersonalCode"] = parameter;
report.Render();
report.Show();

Fourth Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load("mrt file path");
report.Compile();
Stimulsoft.Report.Dictionary.StiVariable parameter = new Stimulsoft.Report.Dictionary.StiVariable("PersonalCode", typeof(int));
parameter.Value = "932";
report.Dictionary.Variables["PersonalCode"] = parameter;
report.Render();
report.Show();

Please help my,
How I can pass a value as parameter to report in .net that this parameter is a parameter for stored procedure that provide report data?

Posted 30-Jun-13 23:50pm

Reza Alipour Fard

Updated 23-Sep-20 10:37am

v2

Add a Solution

Comments

Reza Ss 20-Jun-21 10:46am

How to get path of mrt file

Reza Ss 20-Jun-21 10:48am

How to get path of mrt file in web page

6 solutions

Solution 1

Open a support ticket with your question at Stimulsoft forums on :
http://forum.stimulsoft.com/[^]
There you get full support for the software developers also you provide them with code sample of your work.
Thank you

Posted 2-Jul-13 2:52am

Tammam Koujan

Solution 3

Hi
I solve my problem by bellow code:
Collapse | Copy Code
report.Compile();
report["Number"] = 932;
report.Render();
report.Show();

But You must attention to bellow notice:
1- Stored procedure parameter names's must be "Number"
2- Report parameter name's must be "Number"
3- Sent parameter name's must be "Number"

Thanks

Posted 2-Jul-13 22:17pm

Reza Alipour Fard

Solution 4

Please try to use the following code for set the parameters value:

C#

report.Dictionary.DataSources["DataSourceName"].Parameters["ParameterName"].ParameterValue = yourValue;

Posted 17-Nov-15 22:17pm

Leshik_sat

Solution 5

StiReport report = new StiReport();
            report.Compile();
            Stimulsoft.Report.Dictionary.StiDataParameter parameter = new Stimulsoft.Report.Dictionary.StiDataParameter();
            parameter.Name = "Active";
            parameter.Value = "9";
            report.Load(@"D:\data\MRT\deliveryorder.mrt");
            report.DataSources["vw_vendorCopy"].Parameters["Active"] = parameter;

Posted 20-Feb-17 16:17pm

raditawan

Solution 7

This worked for me.

C#

var report = new StiReport();
report.Compile();
// Set report parameters or variables
var parameter = new Stimulsoft.Report.Dictionary.StiVariable("variableName","variableValue");
report.Dictionary.Variables["variableName"] = parameter;
//...

Posted 23-Sep-20 10:38am

Seesi

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Reza Alipour Fard · Accepted Answer · 2013-07-02T22:15:00

Solution 2

Hi
I solve my problem by bellow code:

report.Compile();
report["Number"] = 932;
report.Render();
report.Show();

But You must attention to bellow notice:
1- Stored procedure parameter names's must be "Number"
2- Report parameter name's must be "Number"
3- Sent parameter name's must be "Number"

Thanks

Posted 2-Jul-13 22:15pm

Reza Alipour Fard

Updated 2-Jul-13 22:16pm

v2