Click here to Skip to main content
15,900,424 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi all,

I have created one crystal report in Crystal Report XI using stored procedure

My stored procedure has four parameters:
1.@intFilterType
2.@strIDs
3.@dtfromDate
4.@dtToDate

from .aspx page I pass the value to these parameters. I want to use the same web.config connectionstring for my crystal report too. I don't want crystal reports to logon when reports run.
So, please help me.

Report.aspx page is given below.

C#
protected void Page_Load(object sender, EventArgs e)
{
  TextBox1.Text = Session["Selected"].ToString();
  TextBox2.Text = Session["ReportBy"].ToString();
  TextBox3.Text = Session["FromDate"].ToString();
  TextBox4.Text = Session["ToDate"].ToString();
  CrystalReportSource1.Report.FileName = Server.MapPath("Reports/RptExpiryListByitem.rpt");
  ParameterDiscreteValue objDiscreteValue;
  ParameterField objParameterField;
  objDiscreteValue = new ParameterDiscreteValue();
  objParameterField = new ParameterField();
  objDiscreteValue.Value =TextBox1.Text;
  objParameterField = CrystalReportViewer1.ParameterFieldInfo["@strIDs"];
  objParameterField.CurrentValues.Add(objDiscreteValue);
  CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);
  objDiscreteValue.Value = TextBox2.Text;
  objParameterField = CrystalReportViewer1.ParameterFieldInfo["@intFilterType"];
  objParameterField.CurrentValues.Add(objDiscreteValue);
  CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);
  objDiscreteValue.Value = TextBox3.Text;
  objParameterField = CrystalReportViewer1.ParameterFieldInfo["@dtFromDate"];
  objParameterField.CurrentValues.Add(objDiscreteValue);
  CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);
  objDiscreteValue.Value = TextBox4.Text;
  objParameterField = CrystalReportViewer1.ParameterFieldInfo["@dtToDate"];
  objParameterField.CurrentValues.Add(objDiscreteValue);
  CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);
  CrystalReportViewer1.ReportSourceID = "CrystalReportSource1";
}
Posted
Updated 8-Nov-10 1:25am
v2

1 solution

The following thread will help you.

Crystal Report Run time Logon problem[^]
 
Share this answer
 

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