public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PDCManagementCR rpt = new PDCManagementCR(); rpt.Site = this.Site; return(rpt); }
private void btnSave_Click(object sender, EventArgs e) { /* * Getting the min and max of date for parameter */ var dateTimes = dataGridView1.Rows.Cast <DataGridViewRow>() //.Select(x => (DateTime) x.Cells["ColumnName"].Value); //if column type datetime //or .Select(x => Convert.ToDateTime(x.Cells["ChequeDate"].Value)); var minValue = dateTimes.Min(); var maxValue = dateTimes.Max(); //ATM REPORT CrystalDecisions.Shared.TableLogOnInfo li; //Print Purposes using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); string qry; if (str == "") { qry = "SELECT TOP 50 * FROM vw_PDCManagementReportV2 ORDER BY ChequeDate,EmpName ASC"; } else { qry = str; } SqlDataAdapter adapter = new SqlDataAdapter(qry, con); DataTable dt = new DataTable(); DataSet ds = new DataSet(); PDCFolder.PDCManagementCR cr = new PDCFolder.PDCManagementCR(); PDCFolder.PDCReport rpt = new PDCFolder.PDCReport(); li = new TableLogOnInfo(); li.ConnectionInfo.IntegratedSecurity = false; adapter.Fill(ds, "vw_PDCManagementReportV2"); dt = ds.Tables["vw_PDCManagementReportV2"]; cr.SetDataSource(ds.Tables["vw_PDCManagementReportV2"]); if (str != "" && dtChequeDateFrom.Checked == true && dtChequeDateTO.Checked == true) { cr.SetParameterValue("pdcDUe", "PDC Due From " + dtChequeDateFrom.Text + " To " + dtChequeDateTO.Text); } else { cr.SetParameterValue("pdcDUe", "PDC Due From " + minValue.ToShortDateString() + " To " + maxValue.ToShortDateString()); } //cr.SetParameterValue("printedBy", Classes.clsUser.Username); cr.SetParameterValue("printedBy", "Nikko"); //cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW"); cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog); rpt.crystalReportViewer1.ReportSource = cr; rpt.ShowDialog(); } }