Hi there,
I have got a Crystal Report developed with Crystal Reports 2008. I am using ASP.Net 2005 (C#) and am trying to call the report from the web page. I have a couple of questions since I am doing this for the first time.
1) Do I need to create a seperate connection to the sub reports too in my
C# code. If yes, how do I do that?
2) My report has got two main parameters, Start Date and End Date. Do I have to pass the parameters to the sub reports too from my C# code?
Can anyone please help me with this ?
Thanks in advance.
Savs.
Here is my code :
DateTime dtStartDate = DateTime.Parse(tbxFromDate.Text);
DateTime dtEndDate = DateTime.Parse(tbxToDate.Text);
CrystalReportViewer1.ReportSource = Server.MapPath("MyReport.rpt");
CrystalReportViewer1..ServerName = "ServerIP";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "sa";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "DBName";
CrystalReportViewer1.RefreshReport();
ParameterFields myParams = new ParameterFields();
ParameterField myParam1 = new ParameterField();
ParameterField myParam2 = new ParameterField();
ParameterDiscreteValue myDiscreteValue1 = new ParameterDiscreteValue();
ParameterDiscreteValue myDiscreteValue2 = new ParameterDiscreteValue();
myParam1.ParameterFieldName = "StartDate";
myParam2.ParameterFieldName = "EndDate";
myDiscreteValue1.Value = dtStartDate;
myParam1.CurrentValues.Add(myDiscreteValue1);
myDiscreteValue2.Value = dtEndDate;
myParam2.CurrentValues.Add(myDiscreteValue2);
myParams.Add(myParam1);
myParams.Add(myParam2);
// Assign the params collection to the report viewer
CrystalReportViewer1.ParameterFieldInfo = myParams;