Click here to Skip to main content
15,886,035 members
Please Sign up or sign in to vote.
1.80/5 (2 votes)
See more:
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
Posted
Updated 24-Mar-20 6:06am

 
Share this answer
 
v2
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();
 
Share this answer
 
v3

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900