Showing posts with label Crystal report. Show all posts
Showing posts with label Crystal report. Show all posts

How to use Crystal reports?

How to connect to Crystal report?
How to use stored procedures at Crystal reports?
How to pass parameter to Crystal report?

1
2 ReportDocument reportDocument = new ReportDocument();
3 ParameterField paramField = new ParameterField();
4 ParameterFields paramFields = new ParameterFields();
5 ParameterDiscreteValue paramDiscreteValue =
new
ParameterDiscreteValue();
6
7 /***********************************/
8
9 paramField.Name = "@ID";
10 paramDiscreteValue.Value = textBox.Text;
11 paramField.CurrentValues.Add(paramDiscreteValue);
12 paramFields.Add(paramField);
13 CrystalReportViewer.ParameterFieldInfo = paramFields;
14
15 reportDocument.Load(Server.MapPath("Report.rpt"));
16 CrystalReportViewer1.ReportSource = reportDocument;
17 reportDocument.SetDatabaseLogon("myUsername", "myPassword",
18 "192.187.1.1", "myDatabase");

Reference