将值传递给Stimulsoft报告参数 [英] Pass a value to Stimulsoft report parameter

问题描述

您好b $ b

我在Windows窗体应用程序中有一个报告，它是由Stimulsoft报告生成器设计的。我的报告通过存储过程从MySQL数据库获取数据。

我的存储过程有一个参数作为PersonalCode，我的报告有一个同名参数。

我想要加载报告文件并将值传递给此参数。

我使用下面列出的一些解决方案，但所有这些解决方案都不正确：

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();

请帮助我，

如何通过value作为报告.net的参数，该参数是提供报告数据的存储过程的参数？

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?

推荐答案

您好b $ b

我用下面的代码解决了我的问题：

Hi
I solve my problem by bellow code:

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

但是你必须注意以下通知：

1 - 存储过程参数名称必须为数字

2-报告参数名称必须为数字

3-发送的参数名称必须为数字



谢谢

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

在Stimulsoft论坛上用你的问题打开支持票：

http://forum.stimulsoft.com/ [ ^ ]

您可以获得对软件开发人员的全面支持，同时为他们提供工作代码示例。

谢谢

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

您好b $ b

我用下面的代码解决了我的问题：

折叠|复制代码

report.Compile（）;

report [Number] = 932;

report.Render（）;

report.Show（）;



但是你必须注意以下通知：

1-存储过程参数名称必须是数字

2-报告参数名称必须是数字

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

这篇关于将值传递给Stimulsoft报告参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！