public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { AccountCrystalReport1 rpt = new AccountCrystalReport1(); rpt.Site = this.Site; return(rpt); }
private void showreportbutton_Click(object sender, EventArgs e) { SqlConnection connction = new SqlConnection(); string Link = @"Data Source = DESKTOP-6LMCH95\SQLEXPRESS;Database = SMS;Integrated Security = SSPI"; connction.ConnectionString = Link; connction.Open(); string query = "Select AID,AdmissonFee,SemisterFee,TutionFee,TotalPaid,Due,Waiver From Account"; SqlCommand cmd = new SqlCommand(query, connction); SqlDataAdapter sda = new SqlDataAdapter(); DataTable dt = new DataTable(); sda.SelectCommand = cmd; sda.Fill(dt); AccountCrystalReport1 aCR = new AccountCrystalReport1(); aCR.SetDataSource(dt); crystalReportViewer2.ReportSource = aCR; }