如何在asp.net()中传递水晶报表中的参数c# [英] how can pass parameter in crystal report in asp.net()c#
本文介绍了如何在asp.net()中传递水晶报表中的参数c#的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尊敬的先生/妈妈
我是Shailendra singh。我是.net开发人员。我想在asp.net中通过参数数据显示CystalReport获取多个表。如何在asp.net(C#)中逐步进行。请帮助我这是非常有说服力的工作。
感谢您提前
shailendra singh
解决方案
http://www.csharpaspnetarticles.com/2009/07/创建-crystal-reports-in-aspnet.html
解决方案1中的链接mentioend现已破损!!,请您更新链接吗?
此解决方案适用于我。
//为报告文件声明变量
静态ReportDocument rpt = new ReportDocument();
//使用正确的报告文件位置加载报告文档
ReportFileName = Server .MapPath(@RPTGenerateTariffWiseSalesReport.rpt);
rpt.Load(ReportFileName,OpenReportMethod.OpenReportByTempCopy);
//初始化&分配参数值
DateTime TodaysDate;
string CompanyCode;
CompanyCode = SearchParams [CompanyCode]。ToString();
TodaysDate = DateTime.Parse(SearchParams [TodaysDate]。ToString());
//使用setParameterValues传递报表中的参数值
rpt.SetParameterValue(@ CompanyCode,CompanyCode);
rpt.SetParameterValue( @TodaysDate,TodaysDate);
//将新的ReportDocument作为报告源分配给ReportViewer
TariffWiseSalesReportViewer.ReportSource = rpt;
//刷新报告
TariffWiseSalesReportViewer.RefreshReport();
这是传递参数的代码水晶报告
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Convert.ToInt32(textBox1.Text);
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions [Price];
crParameterValues = crParameterFieldDefinition.CurrentValues;
完整源代码... 将参数传递给Crystal Reports
Johnson
Dear sir/mam
I am Shailendra singh. I am .net Developer .I want to Show CystalReport in asp.net by parameter data fetch more than one table.How can possible step by step process in asp.net(C#).Please help me It is very argent work .
Thanks for Advance
shailendra singh
解决方案
http://www.csharpaspnetarticles.com/2009/07/creating-crystal-reports-in-aspnet.html
Link mentioend in Solution1 is broken now !!, can u please update link ?
This solution is worked for me.
// Declare Variable for Report Document
static ReportDocument rpt = new ReportDocument();
// Load Report Document with proper report file location
ReportFileName = Server.MapPath(@"RPTGenerateTariffWiseSalesReport.rpt");
rpt.Load(ReportFileName, OpenReportMethod.OpenReportByTempCopy);
//Initialise & Assign Parameter Values
DateTime TodaysDate;
string CompanyCode;
CompanyCode = SearchParams["CompanyCode"].ToString();
TodaysDate = DateTime.Parse(SearchParams["TodaysDate"].ToString());
//Pass Parameter Values in Report using setParameterValues
rpt.SetParameterValue("@CompanyCode", CompanyCode);
rpt.SetParameterValue("@TodaysDate", TodaysDate);
// Assign new ReportDocument to ReportViewer as Report Source
TariffWiseSalesReportViewer.ReportSource = rpt;
//Refresh Report
TariffWiseSalesReportViewer.RefreshReport();
Here is the code for passing parameter to crystal reports
ParameterFieldDefinitions crParameterFieldDefinitions ;
ParameterFieldDefinition crParameterFieldDefinition ;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Convert.ToInt32(textBox1.Text);
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Price"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
full source code...Passing parameter to Crystal Reports
Johnson
这篇关于如何在asp.net()中传递水晶报表中的参数c#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文