private void CrystalReport2() { Cursor.Current = Cursors.WaitCursor; string strServer = "tcp:192.168.1.100,49172"; string strDatabase = "SrisDb"; string strUserId = "miso_server"; string strPwd = "miso4321"; var month = metroComboBox1.GetItemText(metroComboBox1.SelectedItem); var year = metroComboBox2.GetItemText(metroComboBox2.SelectedItem); crystalReportViewer1.SelectionFormula = "monthname(month({ServiceRequestInfoes.DateAccomplished})) Like '*" + month + "*'" + " AND " + "Year({ServiceRequestInfoes.DateAccomplished})= " + year + " AND {ServiceRequestInfoes.Status} = True"; rpt_Monthly report1 = new rpt_Monthly(); report1.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserId, strPwd); report1.SetParameterValue("MonthLabel", month); // report1.SetParameterValue("param_year", year); crystalReportViewer1.ShowPrintButton = true; crystalReportViewer1.ShowExportButton = true; crystalReportViewer1.ReportSource = report1; Cursor.Current = Cursors.Default; }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rpt_Monthly rpt = new rpt_Monthly(); rpt.Site = this.Site; return(rpt); }
private void bt_MonthlyReport_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; var month = metroComboBox1.GetItemText(metroComboBox1.SelectedItem); var year = metroComboBox2.GetItemText(metroComboBox2.SelectedItem); crystalReportViewer1.SelectionFormula = "monthname(month({ServiceRequestInfoes.DateAccomplished})) Like '*" + month + "*'" + " AND " + "Year({ServiceRequestInfoes.DateAccomplished})= " + year + ""; //crystalReportViewer1.SelectionFormula = "monthname(month({ServiceRequestInfoes.DateAccomplished})) Like '*" + month + "*'"; rpt_Monthly report1 = new rpt_Monthly(); report1.SetParameterValue("MonthLabel", month); crystalReportViewer1.ShowPrintButton = true; crystalReportViewer1.ShowExportButton = true; crystalReportViewer1.ReportSource = report1; Cursor.Current = Cursors.Default; }