public void ShowExenseSheet(string vNarration, DataTable dt)
{
try
{
DataTable dt1;
objDAL.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString;
dt1 = objDAL.getCompanyInfo();
CrpExpenseSheet Rpt = new CrpExpenseSheet();
Rpt.Database.Tables[0].SetDataSource(dt);
Rpt.Database.Tables[1].SetDataSource(dt1);
Rpt.SetParameterValue("PeriodNarration", vNarration);
Rpt.SetParameterValue("NetSales", 0);
Rpt.SetParameterValue("OpStockVal", 0);
Rpt.SetParameterValue("NetPurchases", 0);
Rpt.SetParameterValue("CurrentStockVal", 0);
this.CRViewer.ReportSource = Rpt;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Error");
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrpExpenseSheet rpt = new CrpExpenseSheet();
rpt.Site = this.Site;
return(rpt);
}