如何在asp.net（）中传递水晶报表中的参数c＃ [英] how can pass parameter in crystal report in 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屋！