示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            SalesReport rpt = new SalesReport();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string         sql = "Select sm.BillNo,sm.admno,st.sname,st.cstandard as [Standard],sm.Discount,sm.Amount as [BillAmount],sm.CurrDate from tbl_SalesMaster sm inner join tbl_student st on sm.admno=st.adno  where sm.currDate between'" + Convert.ToDateTime(dateTimePicker1.Value.ToString()).ToString("yyyy-MMM-dd") + "'  and '" + Convert.ToDateTime(dateTimePicker2.Value.ToString()).ToString("yyyy-MMM-dd") + "' GROUP BY sm.BillNo,sm.admno,st.sname,st.cstandard,sm.Discount,sm.Amount,sm.CurrDate order by sm.BillNo";
            SqlDataAdapter da  = new SqlDataAdapter(sql, d.con);
            DataSet        ds  = new DataSet();

            da.Fill(ds);
            double  tt = 0;
            DataRow dr;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                dr = ds.Tables[0].Rows[i];
                tt = Convert.ToDouble(dr[5].ToString()) + tt;
            }
            SalesReport sr = new SalesReport();

            sr.SetDataSource(ds.Tables[0]);
            sr.SetParameterValue("FrmMnth", Convert.ToString(Convert.ToDateTime(dateTimePicker1.Value.ToString()).ToString("yyyy-MMM-dd")));
            sr.SetParameterValue("ToMnth", Convert.ToString(Convert.ToDateTime(dateTimePicker2.Value.ToString()).ToString("yyyy-MMM-dd")));
            sr.SetParameterValue("TT", tt.ToString());
            crystalReportViewer1.ReportSource = sr;
        }