public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportcreditor rpt = new CrystalReportcreditor();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectme"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT dbo.GLedger.Date, dbo.GLedger.Naration, ISNULL(dbo.GLedger.Debit, 0) AS Debit, ISNULL(dbo.GLedger.Credit, 0) AS Credit, dbo.GLedger.Balance, dbo.GLedger.[user] FROM dbo.credit_sales LEFT OUTER JOIN dbo.Credit_Customers ON dbo.credit_sales.credit_customerID = dbo.Credit_Customers.credit_customerID LEFT OUTER JOIN dbo.GLedger ON dbo.Credit_Customers.credit_customerID = dbo.GLedger.credit_customerID LEFT OUTER JOIN dbo.creditPayment ON dbo.GLedger.credit_customerID = dbo.creditPayment.credit_customerID WHERE (dbo.Credit_Customers.BussinessName = '" + cmbCreditorsName.Text + "') AND (dbo.GLedger.Date BETWEEN '" + dateTimePicker1.Value + "' AND '" + dateTimePicker2.Value + "') GROUP BY ISNULL(dbo.GLedger.Debit, 0), ISNULL(dbo.GLedger.Credit, 0), dbo.GLedger.Balance, dbo.GLedger.credit_customerID, dbo.Credit_Customers.BussinessName, dbo.GLedger.Naration, dbo.GLedger.Date, dbo.GLedger.[user]", conn);
SqlDataAdapter dscmd = new SqlDataAdapter(cmd);
DataSet2 ds = new DataSet2();
dscmd.Fill(ds, "GLedger");
ds.Tables[0].TableName = "GLedger";
CrystalReportcreditor objRpt = new CrystalReportcreditor();
objRpt.SetDataSource(ds);
objRpt.SetParameterValue("Name", cmbCreditorsName.Text);
objRpt.SetParameterValue("Telephone", tel);
objRpt.SetParameterValue("Address", Add);
//objRpt.SetDataSource(ds.GLedger.Select(c => new
//{
// Date = c.Date,
// Naration = c.Naration,
// Debit = c.Debit,
// Credit = c.Credit,
// Balance = c.Balance,
// user = c.user
//}));
//this.CrystalReportcreditor1.reo
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
////}
}