Calling multiple crystal reports using radio button

Question

Hi , I have to create one form in c# with data from Oracle, i managed to run the crystal report from c#form but i have three diferent reports report1.rpt , report2.rpt and report3.rpt. if i am pressing the radio button 1 first report should report1.rpt should be viewed and if i choose radio buttton 2 then report2.rpt should run. Basically there are two text fields as parameters on the forms which will be passed to fetch the data from oracle . How can i go about it. Appreciate if someone can help.

Nilesh Sawardekar · Answer

Below is method to call crystal report file, private void ReportView( string fileName, string strSQL, string tableName) { CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.Windows.Forms.CrystalReportViewer CrystalReportViewer = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); CrystalReportViewer.ActiveViewIndex = 0; CrystalReportViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; CrystalReportViewer.DisplayGroupTree = false ; CrystalReportViewer.Dock = System.Windows.Forms.DockStyle.Fill; CrystalReportViewer.Location = new System.Drawing.Point(0, 0); CrystalReportViewer.Name = "CrystalReportViewer" ; SqlDataAdapter sadp = new SqlDataAdapter(strSQL, clsVar.con); DataSet ds = new DataSet(); sadp.Fill(ds, tableName); Report.Load(fileName); Report.SetDataSource(ds); CrystalReportViewer.ReportSource = Report; Report.SetDatabaseLogon( "username" , "password" ); CrystalReportViewer.ShowExportButton = true ; CrystalReportViewer.ShowPageNavigateButtons = true ; CrystalReportViewer.ShowCloseButton = true ; CrystalReportViewer.ShowPrintButton = true ; CrystalReportViewer.ShowZoomButton = true ; //frmCrystalReport form is created with no controls and no code. frmCrystalReport frm = new frmCrystalReport(); frm.StartPosition = FormStartPosition.CenterParent; frm.Show(); frm.Left = 0; frm.Top = 0; frm.Controls.Add(CrystalReportViewer); } In your method call above method, if (rbReport1.Checked == true ) { ReportView(report1Path, "query1" , "tableName" ); } else if (rbReport2.Checked == true ) { ReportView(report1Path, "query2" , "tableName" ); } else if (rbReport3.Checked == true ) { ReportView(report3Path, "query3" , "tableName" ); }

Nilesh Sawardekar · Answer

Calling crystal report is nothing but calling crystal report file path, if you are using crystal report from externally. So by simple if else you can call to specific file. Create method for viewing report with file name as parameter and sql query as other parameter. Simple call this method in every if else of radio button. I can provide you code if you want.

Amit Mohanty · Answer

Define crReportDocument such that it is in-scope for the whole form: ReportDocument crReportDocument; and in the button_click... if (rbtn1.Checked == true ) { crReportDocument = new CrystalReport1(); } if (rbtn2.Checked == true ) { crReportDocument = new CrystalReport2(); }

Arif Mohammed · Answer

Thanks Nilesh, appreciate if you can give me the code.