public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptMembershipMainPageNonPayroll rpt = new rptMembershipMainPageNonPayroll(); rpt.Site = this.Site; return(rpt); }
private void label9_Click(object sender, EventArgs e) { //All ACTIVE CrystalDecisions.Shared.TableLogOnInfo li; //Print Purposes using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); //Change from Active Members to Non-Payroll Members SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM vw_MembershipReport where isActive = 1 and isApprove = 1 and Company_Code = 'COMP010'", con); DataTable dt = new DataTable(); DataSet ds = new DataSet(); ReportsForms.rptMembershipMainPageNonPayroll cr = new ReportsForms.rptMembershipMainPageNonPayroll(); ReportsForms.rptMembershipMain rpt = new ReportsForms.rptMembershipMain(); li = new TableLogOnInfo(); li.ConnectionInfo.IntegratedSecurity = false; adapter.Fill(ds, "vw_MembershipReport"); dt = ds.Tables["vw_MembershipReport"]; cr.SetDataSource(ds.Tables["vw_MembershipReport"]); cr.SetParameterValue("status", "Non-Payroll Members"); //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(); } }