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;
}
}