public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
QuotationEval rpt = new QuotationEval();
rpt.Site = this.Site;
return(rpt);
}
private void bindReports()
{
string strRptPath = Server.MapPath(".");
DataTable dtbl = new DataTable();
// DataSet ds = new DataSet();
DataTable ReqInfo = new DataTable();
ReqInfo = (DataTable)Session["Tabl1"];
DataTable IntemInfo = new DataTable();
IntemInfo = (DataTable)Session["Tabl2"];
DataTable SupInfo = new DataTable();
SupInfo = (DataTable)Session["Tabl3"];
ConnectionInfo cInfo = new ConnectionInfo();
TableLogOnInfo logOnInfo = new TableLogOnInfo();
//string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["elogcon"].ToString();
//cInfo.ServerName = "elogsrv";
//cInfo.DatabaseName = "eLog";
//cInfo.UserID = "sa";
//cInfo.Password = "******";
string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["smsconn"].ToString();
string[] conn = connstring.ToString().Split(';');
string[] serverInfo = conn[0].ToString().Split('=');
string[] DbInfo = conn[1].ToString().Split('=');
string[] userInfo = conn[2].ToString().Split('=');
string[] passwordInfo = conn[3].ToString().Split('=');
cInfo.ServerName = serverInfo[1].ToString();
cInfo.DatabaseName = DbInfo[1].ToString();
cInfo.UserID = userInfo[1].ToString();
cInfo.Password = passwordInfo[1].ToString();
DataTable dtitem = new DataTable();
dtitem = ceateTable(IntemInfo, SupInfo);
CrystalReportsFile.QuotationEval objQtyReport = new CrystalReportsFile.QuotationEval();
foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objQtyReport.Database.Tables)
{
logOnInfo = reportTable.LogOnInfo;
logOnInfo.ConnectionInfo = cInfo;
reportTable.ApplyLogOnInfo(logOnInfo);
}
objQtyReport.Load(strRptPath + "\\QuotationEval.rpt");
//objQtyReport.DataDefinition.FormulaFields[1].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString();
//objQtyReport.DataDefinition.FormulaFields[2].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString();
//objQtyReport.DataDefinition.FormulaFields[3].Text = ReqInfo.Rows[0]["SYSTEM_Description"].ToString();
//objQtyReport.DataDefinition.FormulaFields[4].Text = ReqInfo.Rows[0]["TOTAL_ITEMS"].ToString();
//objQtyReport.DataDefinition.FormulaFields[5].Text = ReqInfo.Rows[0]["requestion_Date"].ToString();
//objQtyReport.DataDefinition.FormulaFields[6].Text = ReqInfo.Rows[0]["REQUISITION_CODE"].ToString();
objQtyReport.OpenSubreport("SubReportsForSupp").SetDataSource(SupInfo);
objQtyReport.OpenSubreport("RequsitionDetail").SetDataSource(ReqInfo);
objQtyReport.SetDataSource(dtitem);
CrystalReportViewer.ReportSource = objQtyReport;
CrystalReportViewer.ParameterFieldInfo = paramFields;
CrystalReportViewer.DisplayToolbar = true;
}
