I know this is a long time after the last post, but I've been looking everywhere for a solution. Finally, after a lot of trial and error I got a solution to "Passing Parameters CR 2008 VS 2008 ASP.net"
Hope this can help someone.
The report needs 2 parameters: @MainCnt and @PrdCnt declared in a stored procedure
First update CR to the newest SP. Currently SP2. Place a CrystalReportViewer and CrystalReportsource component on the aspx web form.
Add references:
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
Then, the code to display the report:
protected void btnShow_Click(object sender, EventArgs e)
{
ReportDocument crRpt = new ReportDocument();
crRpt.Load(Server.MapPath("internRecievedPerContract.rpt")); //CR designed in VS2008
crRpt.SetDatabaseLogon("Username", "Passord", "ServerName", "DatabaseName"); //logon data for your server
crRpt.SetParameterValue("@MainCnt", txtMainCnt.Text);
crRpt.SetParameterValue("@PrdCnt", txtPrdCnt.Text); //Textboxes on aspx page for user input
CrystalReportViewer1.ReportSource = crRpt;
}
and if you need to print the report from code, not using the print button on the toolbar:
protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument crRpt = new ReportDocument();
crRpt.Load(Server.MapPath("internRecievedPerContract.rpt")); //CR designed in VS2008
crRpt.SetDatabaseLogon("Username", "Passord", "ServerName", "DatabaseName"); //logon data for your server
crRpt.SetParameterValue("@MainCnt", txtMainCnt.Text);
crRpt.SetParameterValue("@PrdCnt", txtPrdCnt.Text); //Textboxes on aspx page for user input
crRpt.PrintToPrinter(1, false, 0, 0);
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.