public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PDCLoanListing rpt = new PDCLoanListing(); rpt.Site = this.Site; return(rpt); }
private void button1_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); li = new TableLogOnInfo(); PDCFolder.PDCLoanListing cr = new PDCFolder.PDCLoanListing(); li.ConnectionInfo.IntegratedSecurity = false; //PARAMETERS cr.SetParameterValue("pdcDate", "PDC FROM : " + dtLoanFrom.Text + " To " + dtLoanTo.Text); cr.SetParameterValue("printedBy", Classes.clsUser.Username.ToString()); cr.SetParameterValue("@loanDateFrom", dtLoanFrom.Text); cr.SetParameterValue("@loanDateTo", dtLoanTo.Text); //cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW"); cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog); crystalReportViewer1.ReportSource = cr; } }