protected void Page_Load(object sender, EventArgs e) { Rep_DepositPositionProductWiserpt rd = new Rep_DepositPositionProductWiserpt(); ConnectionInfo conne = new ConnectionInfo(); conne.ServerName = ConfigurationManager.AppSettings["ServerName"].ToString(); conne.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"].ToString(); conne.UserID = ConfigurationManager.AppSettings["UserID"].ToString(); conne.Password = ConfigurationManager.AppSettings["Password"].ToString(); TableLogOnInfo tablelogs = new TableLogOnInfo(); Database db = rd.Database; Tables tbls = db.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table tab in tbls) { tablelogs = tab.LogOnInfo; tablelogs.ConnectionInfo = conne; tab.ApplyLogOnInfo(tablelogs); tab.Location = ConfigurationManager.AppSettings["DatabaseName"] + ".dbo." + tab.Name; //most important line whole report is depend on this line } CrystalReportViewer1.ReportSource = rd; CrystalReportViewer1.Zoom(Convert.ToInt16(ConfigurationManager.AppSettings["ReportZoom"])); CrystalReportViewer1.SelectionFormula = "{REP_BRANCH_BALANCES.ACCT_TYPE} in [115, 116, 137, 136, 138] and {REP_BRANCH_BALANCES.TRANDATE} = cdate('" + txtAsOnDate.Text + "')"; CrystalReportViewer1.RefreshReport(); }
protected void Page_Load(object sender, EventArgs e) { ReportDocument rpt = new ReportDocument(); String rptPath = Server.MapPath("~\\CRfiles"); rpt.Load(rptPath + @"\DeclaracionJurada1.rpt"); //rpt.FileName = rptPath + @"\DeclaracionJurada1.rpt"; if (!IsPostBack) { DataSet data = getDataSwornDeclaration(); Session["data"] = data; } rpt.SetDataSource((DataSet)Session["data"]); rpt.ParameterFields["@CustName"].CurrentValues.Add(Data.CrParameterConvert("NESTLE")); rpt.ParameterFields["@CustAddress"].CurrentValues.Add(Data.CrParameterConvert("DIRECCION")); rpt.ParameterFields["@CustPhone"].CurrentValues.Add(Data.CrParameterConvert("TELEFONO")); rpt.ParameterFields["@CustCode"].CurrentValues.Add(Data.CrParameterConvert("399")); rpt.ParameterFields["@CustNit"].CurrentValues.Add(Data.CrParameterConvert("1-9")); rpt.ParameterFields["@CustLegalRep"].CurrentValues.Add(Data.CrParameterConvert("Representantelegal")); rpt.ParameterFields["@ResolutionRate"].CurrentValues.Add(Data.CrParameterConvert("2020")); rpt.ParameterFields["@ResolutionDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); rpt.ParameterFields["@ExpirationDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); rpt.ParameterFields["@EndDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); rpt.ParameterFields["@IsFrozen"].CurrentValues.Add(Data.CrParameterConvert(false)); CrystalReportViewer1.ReportSource = rpt; //CrystalReportViewer1.ParameterFieldInfo["@CustName"].CurrentValues.Add(pCustomerName); //CrystalReportViewer1.ParameterFieldInfo["@CustAddress"].CurrentValues.Add(pCustomerAddress); //CrystalReportViewer1.ParameterFieldInfo["@CustPhone"].CurrentValues.Add(pCustomerPhone); //CrystalReportViewer1.ParameterFieldInfo["@CustCode"].CurrentValues.Add(pCustomerCode); //CrystalReportViewer1.ParameterFieldInfo["@CustNit"].CurrentValues.Add(pCustomerNit); //CrystalReportViewer1.ParameterFieldInfo["@ResolutionRate"].CurrentValues.Add(pResolutionRate); //CrystalReportViewer1.ParameterFieldInfo["@ResolutionDate"].CurrentValues.Add(pResolutionDate); //CrystalReportViewer1.ParameterFieldInfo["@ExpirationDate"].CurrentValues.Add(pExpirationDate); //CrystalReportViewer1.ParameterFieldInfo["@EndDate"].CurrentValues.Add(pEndDate); //CrystalReportViewer1.ParameterFieldInfo["@CustName"].CurrentValues.Add(Data.CrParameterConvert("NESTLE")); //CrystalReportViewer1.ParameterFieldInfo["@CustAddress"].CurrentValues.Add(Data.CrParameterConvert("DIRECCION")); //CrystalReportViewer1.ParameterFieldInfo["@CustPhone"].CurrentValues.Add(Data.CrParameterConvert("TELEFONO")); //CrystalReportViewer1.ParameterFieldInfo["@CustCode"].CurrentValues.Add(Data.CrParameterConvert("399")); //CrystalReportViewer1.ParameterFieldInfo["@CustNit"].CurrentValues.Add(Data.CrParameterConvert("1-9")); //CrystalReportViewer1.ParameterFieldInfo["@CustLegalRep"].CurrentValues.Add(Data.CrParameterConvert("Representantelegal")); //CrystalReportViewer1.ParameterFieldInfo["@ResolutionRate"].CurrentValues.Add(Data.CrParameterConvert("2020")); //CrystalReportViewer1.ParameterFieldInfo["@ResolutionDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); //CrystalReportViewer1.ParameterFieldInfo["@ExpirationDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); //CrystalReportViewer1.ParameterFieldInfo["@EndDate"].CurrentValues.Add(Data.CrParameterConvert(DateTime.Now)); //CrystalReportViewer1.ParameterFieldInfo["@IsFrozen"].CurrentValues.Add(Data.CrParameterConvert(false)); CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.ReuseParameterValuesOnRefresh = true; CrystalReportViewer1.Zoom(80); CrystalReportViewer1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT Bill_Id,Customer_Email,Product_Amount,No_Products,Delivery_Address,Bill_Date FROM dbo.[Bill]"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); CrystalReportBill cr = new CrystalReportBill(); cr.SetDataSource(dt); CrystalReportViewer1.ReportSource = cr; CrystalReportViewer1.Zoom(75); }
protected void Page_Load(object sender, EventArgs e) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT Order_Id,Bill_Id,Customer_Email,Product_Id,Product_Name,Product_Quantity,Order_Amount,Date FROM dbo.[Order]"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); CrystalReportOrder cr = new CrystalReportOrder(); cr.SetDataSource(dt); CrystalReportViewer1.ReportSource = cr; CrystalReportViewer1.Zoom(75); }
protected void Page_Load(object sender, EventArgs e) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT Customer_name, Customer_email_id, Mobile_No, Customer_address FROM dbo.Customer WHERE Active=@a"; cmd.Parameters.AddWithValue("@a", "yes"); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); CrystalReportCustomer cr = new CrystalReportCustomer(); cr.SetDataSource(dt); CrystalReportViewer1.ReportSource = cr; CrystalReportViewer1.Zoom(75); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { txtDateFrom.Text = DateTime.Now.AddDays(-3).ToString("dd-MMM-yyyy"); txtDateTo.Text = DateTime.Now.ToString("dd-MMM-yyyy"); CrystalReportViewer1.Zoom(Convert.ToInt16(ConfigurationManager.AppSettings["ReportZoom"])); } //conne.ServerName = ConfigurationManager.AppSettings["ServerName"]; // conne.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"]; // conne.UserID = ConfigurationManager.AppSettings["UserID"]; // conne.Password = "******";//ConfigurationManager.AppSettings["Password"]; ConnectionInfo conne = new ConnectionInfo(); conne.ServerName = ConfigurationManager.AppSettings["ServerName"].ToString(); conne.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"].ToString(); conne.UserID = ConfigurationManager.AppSettings["UserID"].ToString(); conne.Password = ConfigurationManager.AppSettings["Password"].ToString(); TableLogOnInfo tablelogs = new TableLogOnInfo(); Database db = rd.Database; Tables tbls = db.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table tab in tbls) { tablelogs = tab.LogOnInfo; tablelogs.ConnectionInfo = conne; tab.ApplyLogOnInfo(tablelogs); tab.Location = ConfigurationManager.AppSettings["DatabaseName"] + ".dbo." + tab.Name; //most important line whole report is depend on this line } CrystalReportViewer1.ReportSource = rd; CrystalReportViewer1.SelectionFormula = "{Rep_SummaryOfDeposit.TranDate} >= cdate('" + txtDateFrom.Text + "') and {Rep_SummaryOfDeposit.TranDate} <=cdate('" + txtDateTo.Text + "')"; CrystalReportViewer1.RefreshReport(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["Bill_Id"] != null) { int i = (int)Session["Bill_Id"]; con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT dbo.[Order].Order_Id, dbo.[Order].Bill_Id, dbo.[Order].Customer_Email, dbo.[Order].Product_Id, dbo.[Order].Product_Name, dbo.[Order].Product_Quantity, dbo.[Order].Order_Amount, dbo.[Order].Date, dbo.Bill.Delivery_Address FROM dbo.Bill INNER JOIN dbo.[Order] ON dbo.Bill.Bill_Id = dbo.[Order].Bill_Id WHERE dbo.[Order].Bill_Id=@w AND dbo.[Bill].Bill_Id=@w"; cmd.Parameters.AddWithValue("@w", i); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); CrystalReportImpBilling cr = new CrystalReportImpBilling(); cr.SetDataSource(dt); CrystalReportViewer1.ReportSource = cr; CrystalReportViewer1.Zoom(75); } else { Response.Redirect("Main.aspx"); } }
private void cmdZoom_Click(object sender, EventArgs e) { CrystalReportViewer1.Zoom(Convert.ToInt32(txtUpDown.Value)); }
private void GenerateReport() { DataSet _ds = new DataSet(); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clsdocument _objcls = new _clsdocument(); _objcls.project_code = lblprj.Text; DataTable _dt = new DataTable(); ReportDocument cryRpt = new ReportDocument(); if (lblprjid.Text != "50") { DataTable _dt1 = new DataTable(); _clsuser _objcls1 = new _clsuser(); _objcls1.project_code = lblprj.Text;; _dt = _objbll.load_ProgressTrackingsheet(_objcls, _objdb); _dt1 = _objbll.Get_Project_Logo(_objcls1, _objdb); //_dt.TableName = "ProgressTrackingReport"; //_dt.WriteXmlSchema(Server.MapPath("") + "\\ProgressTrackingReport.xml"); //_dt1.TableName = "ProjectLogo"; //_dt1.WriteXmlSchema(Server.MapPath("") + "\\ProjectLogo.xml"); if (lblprjid.Text == "57") { cryRpt.Load(Server.MapPath("ProgressTrackingReport_Mc12.rpt")); } else { cryRpt.Load(Server.MapPath("ProgressTrackingReport.rpt")); } cryRpt.Database.Tables[1].SetDataSource(_dt1); } else { _dt = _objbll.load_ProgressTrackingsheet1(_objcls, _objdb); cryRpt.Load(Server.MapPath("ProgressTrackingReport_Oph.rpt")); } cryRpt.Database.Tables[0].SetDataSource(_dt); CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.Zoom(90); CrystalReportViewer1.DataBind(); Session["Report"] = cryRpt; CrystalReportViewer1.RefreshReport(); }
private void ShowCrystalReport() { if (ReportObject.ReportType != null) { switch (ReportObject.ReportType) { case "DailyBuyReport": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyBuyReport(); //dtCommonDataTable.TableName = "DailyBuyReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyBuyReport.rpt"; break; case "DailyLocalSaleReport": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyLocalSaleReport(); //dtCommonDataTable.TableName = "DailyLocalSaleReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyLocalSaleReport.rpt"; break; case "ConsignmentWiseSale": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetConsignmentWiseSaleReport(); //dtCommonDataTable.TableName = "ConsignmentWiseSaleReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/ConsignmentWiseSale.rpt"; break; case "DailyStockReport": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyStockReport(); //dtCommonDataTable.TableName = "DailyStockReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile2.xml"); reportPath = "~/Rpt/DailyStockReport.rpt"; break; case "DailyDueStatement": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyDueStatementReport(); //dtCommonDataTable.TableName = "DailyBuyReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyDueStatement.rpt"; break; case "DailyPayStatement": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyPayStatementReport(); //dtCommonDataTable.TableName = "DailyBuyReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyPayStatement.rpt"; break; case "DailyForeignSaleReport": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyForeignSaleReport(); //dtCommonDataTable.TableName = "DailyForeignSalesReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyForeignSaleReport.rpt"; break; case "DailyPartlyLedger": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyPartlyLedgerReport(); //dtCommonDataTable.TableName = "DailyPartyLedgerReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile.xml"); reportPath = "~/Rpt/DailyPartlyLedger.rpt"; break; case "DailyTotalProductionCost": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyTotalProductionCostReport(); //dtCommonDataTable.TableName = "DailyTotalProductionCost"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFile7.xml"); reportPath = "~/Rpt/DailyTotalProductionCost.rpt"; break; case "IncomeStatementReport": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetIncomeStatementReport(); //dtCommonDataTable.TableName = "IncomeStatementReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFileB.xml"); reportPath = "~/Rpt/IncomeStatementReport.rpt"; break; case "SalesLedgerAccount": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetSalesLedgerAccount(); //dtCommonDataTable.TableName = "SalesLedgerAccountReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFileB.xml"); reportPath = "~/Rpt/SalesLedgerAccountReport.rpt"; break; case "PurchaseLedgerAccount": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetPurchaseLedgerAccount(); //dtCommonDataTable.TableName = "PurchaseLedgerAccountReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/XMLFileB.xml"); reportPath = "~/Rpt/PurchaseLedgerAccountReport.rpt"; break; case "ChequePayment": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetChequePaymentForPurchase(); //dtCommonDataTable.TableName = "ChequePaymentForPurchaseReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/ChequePayment.xml"); reportPath = "~/Rpt/ChequePaymentForPurchaseReport.rpt"; break; case "ChequeReceived": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetChequeReceivedForSale(); //dtCommonDataTable.TableName = "ChequeReceivedForSaleReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/ChequeReceived.xml"); reportPath = "~/Rpt/ChequeReceivedForSaleReport.rpt"; break; case "ConsignmentWiseTruckFare": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetConsignmentWiseTruckFare(); //dtCommonDataTable.TableName = "ConsignmentWiseTruckFairReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/ConsignmentWiseTruckFair.xml"); reportPath = "~/Rpt/ConsignmentWiseTruckFairReport.rpt"; break; case "DailyTotalCostEverySubject": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetDailyTotalCostEverySubject(); //dtCommonDataTable.TableName = "DailyTotalCostEverySubjectReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/DailyTotalCostEverySubject.xml"); reportPath = "~/Rpt/DailyTotalCostEverySubjectReport.rpt"; break; case "BuyerDetail": dtCommonDataTable = new DataTable(); dtCommonDataTable = objReportBLL.GetBuyerDetail(); //dtCommonDataTable.TableName = "BuyerDetailReport"; //dtCommonDataTable.WriteXmlSchema(Server.MapPath(".") + "/BuyerDetail.xml"); reportPath = "~/Rpt/BuyerDetailReport.rpt"; break; default: break; } var document = new ReportDocument(); document.Load(Server.MapPath(reportPath)); document.SetDataSource(dtCommonDataTable); document.SetParameterValue("@DateRange", "Date From " + Convert.ToDateTime(ReportObject.FromDate).ToString("dd/MM/yy") + " To " + Convert.ToDateTime(ReportObject.ToDate).ToString("dd/MM/yy")); CrystalReportViewer1.ReportSource = document; CrystalReportViewer1.DisplayToolbar = true; CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None; CrystalReportViewer1.Zoom(125); } }
protected void Page_Load(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportDocument reportdocument = new ReportDocument(); reportdocument = ReportFactory.GetReport(reportdocument.GetType()); if (!IsPostBack) { string reportname = Request.QueryString["Name"] + ".rpt"; string search = Request.QueryString["Data"]; ContextDto context = new ContextDto(); context.dbMainConnection = ConfigurationManager.ConnectionStrings["dbMainConnection"].ConnectionString; context.dbQLNSConnection = ConfigurationManager.ConnectionStrings["dbQLNSConnection"].ConnectionString; DataSet ds = new DataSet(); if (reportname == "rptBaoCaoCongViec.rpt") { GetListBaoCaoCongViecByCriteraBiz biz = new GetListBaoCaoCongViecByCriteraBiz(context); if (search != null && search != "") { if (search.Split('|').Length > 1) { try { if (search.Split('|')[0] != "" && search.Split('|')[0] != "__/__/____") { biz.TuNgay = DateTime.ParseExact(search.Split('|')[0], "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")).ToString("yyyy-MM-dd"); } } catch { biz.TuNgay = ""; } try { if (search.Split('|')[1] != "" && search.Split('|')[1] != "__/__/____") { biz.DenNgay = DateTime.ParseExact(search.Split('|')[1], "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")).ToString("yyyy-MM-dd"); } } catch { biz.DenNgay = ""; } biz.NhanVien = search.Split('|')[2]; biz.PhongBan = search.Split('|')[3]; biz.LoginId = search.Split('|')[4]; ds = biz.Execute(); } } } ds.Tables[0].TableName = "Tables"; //ds.WriteXmlSchema(@"E:\rptBaoCaoCongViec.xml"); string filepath = Server.MapPath("~/CrystalReport/Report/" + reportname); reportdocument.Load(filepath); reportdocument.SetDataSource(ds); reportdocument.DataDefinition.FormulaFields["tungay"].Text = "'" + search.Split('|')[0] + "'"; reportdocument.DataDefinition.FormulaFields["denngay"].Text = "'" + search.Split('|')[1] + "'"; CrystalReportViewer1.HasCrystalLogo = false; //CrystalReportViewer1.SeparatePages = false; //CrystalReportViewer1.ToolPanelView = ToolPanelViewType.GroupTree; CrystalReportViewer1.Zoom(105); CrystalReportViewer1.ReportSource = reportdocument; Session["ReportDocument"] = reportdocument; } else { reportdocument = Session["ReportDocument"] as ReportDocument; CrystalReportViewer1.ReportSource = reportdocument; } }