private void frmfeesReport_Load(object sender, EventArgs e) { SqlConnection cn = new SqlConnection(Program.myConnection); string qry = "DECLARE @schoolname varchar(100); " + "SET NOCOUNT OFF; " + "SET @schoolname = (SELECT schoolname FROM Schoolinfo) " + "select fees.sid,fees.fees, classes.classname,student.GRno,student.SName,student.FName, @schoolname as schoolname from fees " + "inner join classes on fees.classid = classes.classid " + "inner join student on fees.sid = student.id where status='unpaid'"; SqlDataAdapter adpt = new SqlDataAdapter(qry, cn); //DataTable dt = new DataTable(); DataSet2 ds = new DataSet2(); try { cn.Open(); adpt.Fill(ds.fees); feesReport1 rpt = new feesReport1(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cn.Close(); cn.Dispose(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { feesReport1 rpt = new feesReport1(); rpt.Site = this.Site; return(rpt); }