void expButton_MouseDown(object sender, MouseEventArgs e) { report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass); SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.Filter = "Crystal Report (*.rpt)|*.rpt|Adobe Acrobat (*.pdf)|*.pdf|Microsoft Excel (*.xls)|*.xls|Microsoft Word (*.doc)|*.doc|Rich Text Format (*.rtf)|*.rtf"; saveDialog.Title = "Экспорт рапорта"; saveDialog.ShowDialog(); if (saveDialog.FileName != "") { switch (saveDialog.FilterIndex) { case 1: report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.CrystalReport, @saveDialog.FileName); break; case 2: report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @saveDialog.FileName); break; case 3: report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, @saveDialog.FileName); break; case 4: report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, @saveDialog.FileName); break; case 5: report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.RichText, @saveDialog.FileName); break; default: break; } } }
private CrystalDecisions.CrystalReports.Engine.ReportClass getCrystalReport() { CrystalDecisions.CrystalReports.Engine.ReportClass reportObject = null; if (chkPhotoInvoice.Checked) { reportObject = new InvoiceWithPicture(); } else { reportObject = new InvoiceWithoutPicture(); } customerName = "Manish Madhopuria"; customerAddress = "46,M.A.K.Azad Road, Howrah -711101"; CrystalDecisions.CrystalReports.Engine.TextObject txtObject; txtObject = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.ReportDefinition.ReportObjects["txtName"]; txtObject.Text = customerName; txtObject = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.ReportDefinition.ReportObjects["txtAddress"]; txtObject.Text = customerAddress; // reportObject.SetParameterValue("txtName", customerName); // reportObject.SetParameterValue("txtAddress", customerAddress); // CrystalDecisions.CrystalReports.Engine.TextObject txtCustomerName = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtName"]; // CrystalDecisions.CrystalReports.Engine.TextObject txtCustomerAddress = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtAddress"]; // txtCustomerName.Text = customerName; // txtCustomerAddress.Text = customerAddress; // CrystalDecisions.CrystalReports.Engine.TextObject txtInvoiceType = (CrystalDecisions.CrystalReports.Engine.TextObject)reportObject.Section1.ReportObjects["txtInvoiceType"]; return(reportObject); }
public bool ShowReport(string[] reportTitle, string[] reportData, DataTable dataTbl, CrystalDecisions.CrystalReports.Engine.ReportClass myReport) { try { //============================== // Make report //============================== if (this.ExportOutput != Export.ExportFormat.None) { this.ExportData(dataTbl, this.ExportOutput); } else { myReport.SetDataSource(dataTbl); reportViewer.SetReportPara(myReport.ParameterFields, reportTitle, "reportTitle"); reportViewer.SetReportPara(myReport.ParameterFields, reportData, "reportData"); reportViewer.ShowReport(myReport); myReport.Dispose(); } } catch (Exception er) { common.errorHandler.lastErrorMessage = er.Message.ToString(); return(false); } return(true); }
// This method will allow you may easily set report datasource based on your current SqlServerConnetion public static void SetSqlConnection(CrystalDecisions.CrystalReports.Engine.ReportClass MyReport, SqlConnection MySqlConnection) { // You may even test SqlConnection before using it. SqlConnectionStringBuilder SqlConnectionStringBuilder = new SqlConnectionStringBuilder(MySqlConnection.ConnectionString); string ServerName = SqlConnectionStringBuilder.DataSource; string DatabaseName = SqlConnectionStringBuilder.InitialCatalog; Boolean IntegratedSecurity = SqlConnectionStringBuilder.IntegratedSecurity; string UserID = SqlConnectionStringBuilder.UserID; string Password = SqlConnectionStringBuilder.Password; // Of course, you may add extra settings here :D // On Crystal Reports, connection must be set individually for each table defined on the report document foreach (CrystalDecisions.CrystalReports.Engine.Table Table in MyReport.Database.Tables) { CrystalDecisions.Shared.TableLogOnInfo TableLogOnInfo = Table.LogOnInfo; TableLogOnInfo.ConnectionInfo.ServerName = ServerName; TableLogOnInfo.ConnectionInfo.DatabaseName = DatabaseName; TableLogOnInfo.ConnectionInfo.IntegratedSecurity = IntegratedSecurity; if (IntegratedSecurity != true) { TableLogOnInfo.ConnectionInfo.UserID = UserID; TableLogOnInfo.ConnectionInfo.Password = Password; } Table.ApplyLogOnInfo(TableLogOnInfo); } }
public PrintPreview(CrystalDecisions.CrystalReports.Engine.ReportClass EmpAccRpt) { InitializeComponent(); this.crystalReportViewer1.ReportSource = EmpAccRpt; crystalReportViewer1.Zoom(75); // crystalReportViewer1. }
public InvoiceReportForm(int invID, int patID, DateTime startRange, DateTime endRange) { InitializeComponent(); report = new InvoiceReport(); InvoiceViewModelBindingSource.DataSource = Database.InvoiceViewModel.GetInvoices(invID); report.SetDataSource(InvoiceViewModelBindingSource); crystalReportViewer1.ReportSource = report; }
public static void setSX3InvoiceParams(string hoaDonID, CrystalDecisions.CrystalReports.Engine.ReportClass hd) { hd.SetDataSource(DataTier.fillHoaDon(hoaDonID)); hd.SetParameterValue("ngayBatDau", ngayBatDau); hd.SetParameterValue("ngayKetThuc", ngayKetThuc); hd.SetParameterValue("giaDien1", giaDien); hd.SetParameterValue("giaDien2", giaDienSX3_2); hd.SetParameterValue("ngayKyHD", "Ngày " + ngayKy + "/" + thangKy + "/" + namKy); hd.SetParameterValue("ngayKyHD2", "Ngày " + ngayKy + " tháng " + thangKy + " năm " + namKy); hd.SetParameterValue("tongTienBangChu", docChu); }
private void button1_Click(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ContratoEmpreteiro1; CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["Contrato"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(TxtBoxContrato.Text); report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void Report_Viewer_Load(object sender, EventArgs e) { function.settheme(this); if (module_Rpt.rpt_name.CompareTo("FRM_ITEMMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_ItemMaster"); doc = new RptItemMaster(); doc.Database.Tables["Tbl_ItemMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } else { } }
private void printInvoice(int svno) { InvoicePrinting invoicePrinting = new InvoicePrinting(); DataSet ds = new DataSet(); invoicePrinting.prepareDataSetForInvoiceReport(ds, svno); CrystalDecisions.CrystalReports.Engine.ReportClass report = getCrystalReport(); report.SetDataSource(ds); CrystalDecisions.CrystalReports.Engine.TextObject txtInvoiceType; txtInvoiceType = (CrystalDecisions.CrystalReports.Engine.TextObject)report.ReportDefinition.ReportObjects["txtInvoiceType"]; txtInvoiceType.Text = "Original"; report.PrintToPrinter(1, false, 0, 0); txtInvoiceType.Text = "Duplicate"; report.PrintToPrinter(1, false, 0, 0); }
public ActionResult PrintAssemssment() { try { var cm = new Common(); var A = cm.GetAssessment(); var Ad = cm.GetAssessDetail(); var At = cm.GetAssessType(); var S = cm.GetStudent(); var query = from _A in A from _Ad in Ad from _At in At where _A.ass_id == _Ad.ass_id && _A.ass_type_id == _At.asstype_id.ToString() && _Ad.ass_no == _At.ass_no select new { _At.question, _Ad.answer }; DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("question"); dt.Columns.Add("answer"); foreach (var aa in query) { dr = dt.NewRow(); dr["question"] = aa.question; dr["answer"] = aa.answer; dt.Rows.Add(dr); } if (dt.Rows.Count > 0) { using (CrystalDecisions.CrystalReports.Engine.ReportClass rptH = new CrystalDecisions.CrystalReports.Engine.ReportClass()) { string path = HttpContext.Server.MapPath("~/App_Data/reportPdf.rpt"); rptH.FileName = path; rptH.Load(); rptH.SetDataSource(dt); // rptH.SetParameterValue("isAdmin", (user.Role.RoleName == RoleName.Admintstrator ? "T" : "F")); System.IO.Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); } } return(new EmptyResult()); } catch (Exception ex) { return(new EmptyResult()); } }
private void getRepoData(ref CrystalDecisions.CrystalReports.Engine.ReportClass repo, int l) { if (repo != null) { //repo.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)GetPagerSizeId("京东");//设置打印纸张 string delivery_id = "JDVA01661244585"; string packagecount = l.ToString(); string weight = "5"; string source_sort_center_name = "北京通州分拣中心"; string source_cross_code = "10"; string source_tabletrolley_code = "160-呼市"; string target_sort_center_name = "呼和浩特分拨中心"; string target_tabletrolley_code = "A10-9"; string receive_address = "内蒙古呼和浩特市土默特左旗经济技术开发区金川区宽城小区"; string receive_name = "朱银岭"; string receive_mobile = "15335557302"; string sender_address = "内蒙古呼和浩特市和林格尔县企业总部南300米云谷水岸小区东侧"; string sender_name = "小致"; string sender_mobile = "18301192819"; string order_id = "B20200117155332304748390"; string road = "8"; string site_name = "*呼市金川宽城营业部"; repo.DataDefinition.FormulaFields["bgydh"].Text = "'" + delivery_id + "-" + l.ToString() + "-" + packagecount + "-'"; //包裹运单号(运单号 -包裹序号 -包裹总数 -) repo.DataDefinition.FormulaFields["bgzl"].Text = "'" + weight + "'"; //包裹重量 repo.DataDefinition.FormulaFields["sourcetSortCenterName"].Text = "'" + source_sort_center_name + "'"; //始发分拣中心名称 repo.DataDefinition.FormulaFields["originalCrossCode"].Text = "'" + source_cross_code + "'"; //始发道口号 repo.DataDefinition.FormulaFields["originalTabletrolleyCode"].Text = "'" + source_tabletrolley_code + "'"; //始发车笼号 repo.DataDefinition.FormulaFields["targetSortCenterName"].Text = "'" + target_sort_center_name + "'"; //目的地分拣中心名称 repo.DataDefinition.FormulaFields["destinationCrossCode"].Text = "'" + target_tabletrolley_code + "'"; //目的道口号 repo.DataDefinition.FormulaFields["destinationTabletrolleyCode"].Text = "'" + target_tabletrolley_code + "'"; //目的车笼号 repo.DataDefinition.FormulaFields["sjxx"].Text = "'" + receive_address + " " + receive_name + " " + receive_mobile + "'"; //客户信息【黑体 9 号】:包含收件方姓名、电话、地址 repo.DataDefinition.FormulaFields["ysje"].Text = "'0.00'"; repo.DataDefinition.FormulaFields["ydh"].Text = "'" + delivery_id + "'"; //运单号 repo.DataDefinition.FormulaFields["khxx"].Text = "'" + receive_name + " " + receive_mobile + "'"; //收件客户名称、电话 repo.DataDefinition.FormulaFields["remark"].Text = "''"; //备注 青岛啤酒(Tsingtao)黑啤 /n 500ml * 12听 / 箱 整箱装 包 repo.DataDefinition.FormulaFields["jfkhxx"].Text = "'" + sender_address + " " + sender_name + " " + sender_mobile + "'"; //寄方客户信息 repo.DataDefinition.FormulaFields["sjid"].Text = "'202001151924001'"; //商家ID repo.DataDefinition.FormulaFields["bsjddh"].Text = "'" + order_id + "'"; //商家订单号 repo.DataDefinition.FormulaFields["startCity"].Text = "'" + source_sort_center_name + "'"; //始发城市 repo.DataDefinition.FormulaFields["rode"].Text = "'" + road + "'"; //路区 repo.DataDefinition.FormulaFields["bgxl"].Text = "'" + l.ToString() + "/" + packagecount + "'"; //包裹序列 repo.DataDefinition.FormulaFields["siteName"].Text = "'" + site_name + "'"; //站点名称 repo.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; //纵向打印 } }
private void frmShowReport_Load(object sender, EventArgs e) { if (objReportSource == null) { objReportSource = new crpVuoto(); this.WindowState = FormWindowState.Minimized; bIsToHide = true; timer1.Enabled = true; } else { crViewer.ReportSource = null; crViewer.Show(); crViewer.ReportSource = objReportSource; crViewer.Refresh(); crViewer.Show(); } }
private void GerarButton_Click(object sender, EventArgs e) { if (!checkBox1.Checked) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicao1; CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["DataInicial"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(DataInicialDTP.Value.Date.ToShortDateString()); parm = report.ParameterFields["DataFinal"]; parm.CurrentValues.AddValue(DataFinalDTP.Value.Date.ToShortDateString()); report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); } else { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicaoTOP1; report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); } }
private void CrystalReportPrint() { try { CrystalDecisions.CrystalReports.Engine.ReportClass repo = (CrystalDecisions.CrystalReports.Engine.ReportClass)Assembly.Load("CrystalReportDemo").CreateInstance("CrystalReportDemo.rpt.CrystalReport1"); if (repo != null) { for (int i = 0; i < 4; i++) { getRepoData(ref repo, i); //repo.PrintToPrinter(1, false, 0, 0);//打印 //预览 FrmPrint frmPrint = new FrmPrint(); frmPrint.rpst = repo; frmPrint.ShowDialog(this); } } } catch (Exception ex) { throw ex; } }
private void button1_Click(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.RelatorioMedicao1; this.RelatorioMedicao1.RecordSelectionFormula = ""; if (DotacaoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula = DotacaoFiltro; if (TipoObraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + TipoObraFiltro; if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } else { if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } } else { if (TipoObraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += TipoObraFiltro; if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } else { if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")"; } } else { if (!PeriodoChkBox.Checked) { this.RelatorioMedicao1.RecordSelectionFormula = "{Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")"; } } } } } this.RelatorioMedicao1.Refresh(); CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["Filtro"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(DotacaoFiltro == ""?"":"Dotação Orçamentaria" + " " + TipoObraFiltro == ""?"":"Tipo Orçamento" + " " + BairroFiltro == ""?"":"Bairro" + " " + EmpreteiraFiltro == ""?"":"Empreteira" + " " + PeriodoFiltro == ""?"":"Periodo "); report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop", true); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
public void setReportSource(CrystalDecisions.CrystalReports.Engine.ReportClass Reporte) { this.crvReportes.ReportSource = Reporte; }
public FrmReportes(CrystalDecisions.CrystalReports.Engine.ReportClass Reporte) { InitializeComponent(); this.crvReportes.ReportSource = Reporte; }
public Form_crystal_report(CrystalDecisions.CrystalReports.Engine.ReportClass rpt_class) { InitializeComponent(); crystalReportViewer1.ReportSource = rpt_class; }
void searchButton_MouseDown(object sender, MouseEventArgs e) { report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass); CodeHelper.UI.MessageDialog<TextBox> mesDialog = new MessageDialog<TextBox>("Поиск", "Слово или фраза в документе:", ""); switch (mesDialog.ShowDialog()) { case DialogResult.OK: while (SearchForText(mesDialog[0].Text)) mesDialog.ShowDialog(); MessageBox.Show("Поиск в документе окончен", "Результаты поиска"); break; default: break; } }
private void Report_Viewer_Load(object sender, EventArgs e) { function.settheme(this); //--------*********>>>>>>>>>>>>>>>>> Binding a Report Master Form <<<<<<<<<<<<<<<*********-------- if (module_Rpt.rpt_name.CompareTo("FRM_EMPLOYEEMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_EmployeeMaster"); doc = new RptEmployeeMaster(); doc.Database.Tables["Tbl_EmployeeMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_ITEMMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_ItemMaster"); doc = new RptItemMaster(); doc.Database.Tables["Tbl_ItemMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_CUSTOMERMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_CustomerMaster"); doc = new RptCustomerMaster(); doc.Database.Tables["Tbl_CustomerMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0) { DataSet ds = bl_obj.blFill("SP_TransportationMaster"); doc = new RptTransportationMaster(); doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_EXPENCESMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_ExpencesMaster"); doc = new RptExpencesMaster(); doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_ROWMATERIAL") == 0) { DataSet ds = bl_obj.blFill("SP_RowHedar"); doc = new RptRowMaterial(); doc.Database.Tables["Tbl_RowHedar"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_SUPPLIERMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_SupplierMaster"); doc = new RptSupplierMaster(); doc.Database.Tables["Tbl_SupplierMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0) { DataSet ds = bl_obj.blFill("SP_TransportationMaster"); doc = new RptTransportationMaster(); doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_SUBEXPENCESMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_SubExpencesMaster"); doc = new RptSubExpencesMaster(); doc.Database.Tables["Tbl_SubExpencesMaster"].SetDataSource(ds.Tables[0]); //doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("FRM_MEASUREMENTMASTER") == 0) { DataSet ds = bl_obj.blFill("SP_MeasurementMaster"); doc = new RptMeasurmentMaster(); doc.Database.Tables["Tbl_Measurment"].SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = doc; } //--------*********>>>>>>>>>>>>>>>>> Binding a Report Transaction <<<<<<<<<<<<<<<*********-------- if (module_Rpt.rpt_name.CompareTo("RptSalesInvoice") == 0) { doc = new RptSalesInvoice(); doc.Database.Tables["Tbl_Sales_Invoice"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptPendingInvoice") == 0) { doc = new RptPendingInvoice(); doc.Database.Tables["Tbl_PendingInvoice"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptPendingInvoiceCustomerwise") == 0) { doc = new RptPendingInvoiceCustomerwise(); doc.Database.Tables["Tbl_PendingInvoiceCustomerwise"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptScrapwise") == 0) { doc = new RptScrapwise(); doc.Database.Tables["Tbl_Scrapwise"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptDayBook") == 0) { doc = new rptDayBookNew(); doc.Database.Tables["DayBookNew"].SetDataSource(dataSet1.Tables[0]); //doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]); //doc.ParameterFields.Add("OpeningBal"); //doc.SetParameterValue("OpeningBal",dataSet1.Tables[1].Rows[0][0].ToString()); //doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString()); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptCashBook") == 0) { DataSet ds = new DataSet(); paraname.Clear(); paravalue.Clear(); paraname.Add("@From_Date"); paraname.Add("@flag"); paravalue.Add(_fromdate.ToString("yyyy-MM-dd")); paravalue.Add("OP"); ds = bl_obj.blFill_para_name(paraname, paravalue, "SP_Report"); doc = new rptCashBook(); doc.Database.Tables["CashBookNew"].SetDataSource(dataSet1.Tables[0]); //doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]); //doc.ParameterFields.Add("OpeningBal"); doc.SetParameterValue("OpeningBal", ds.Tables[0].Rows[0][0].ToString()); doc.SetParameterValue("Date", _fromdate); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptSales") == 0) { doc = new RptSales(); doc.Database.Tables["Tbl_Sales"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptPurchase") == 0) { doc = new RptPurchase(); doc.Database.Tables["Tbl_Purchase"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptGeneralLedger") == 0) { doc = new RptGeneralLedger(); doc.Database.Tables["Tbl_GeneralLedger"].SetDataSource(dataSet1.Tables[0]); doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString()); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptTrialBalance") == 0) { doc = new RptTrialBalance(); doc.Database.Tables["Tbl_TrialBalance"].SetDataSource(dataSet1.Tables[0]); //doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]); //doc.ParameterFields.Add("OpeningBal"); doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString()); doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString()); doc.SetParameterValue("ToDate", dataSet1.Tables[1].Rows[0][2].ToString()); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptRoot") == 0) { doc = new RptRoot(); doc.Database.Tables["Tbl_Root"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptFinishedGoods") == 0) { doc = new rptFinishedGoods(); doc.Database.Tables["Tbl_FinishedGoods"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptRowMaterialStock") == 0) { doc = new rptRowMaterialStock(); doc.Database.Tables["Tbl_RowMaterialStock"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptProductionReport") == 0) { doc = new rptProductionReport(); doc.Database.Tables["Tbl_ProductionReport"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } //if (module_Rpt.rpt_name.CompareTo("RptTax") == 0) //{ // doc = new RptTax(); // doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]); // crystalReportViewer1.ReportSource = doc; //} if (module_Rpt.rpt_name.CompareTo("rptCustomerLedgerNew") == 0) { doc = new rptCustomerLedgerNew(); doc.Database.Tables["Tbl_Customer_Ledger_New"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("rptDateWiseAllCustTotal") == 0) { doc = new rptDateWiseAllCustTotal(); doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } //if (module_Rpt.rpt_name.CompareTo("RptDateWiseAllCustomer") == 0) //{ // doc = new RptDateWiseAllCustomer(); // doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]); // crystalReportViewer1.ReportSource = doc; //} if (module_Rpt.rpt_name.CompareTo("rptDebitCreditTransaction") == 0) { doc = new rptDebitCreditTransaction(); doc.Database.Tables["Tbl_DebitCreditTransaction"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RptGSTTax") == 0) { doc = new RptGSTTax(); doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } if (module_Rpt.rpt_name.CompareTo("RPTGSTR") == 0) { doc = new RPTGSTR(); doc.Database.Tables["Tbl_GSTR"].SetDataSource(dataSet1.Tables[0]); crystalReportViewer1.ReportSource = doc; } else { } }
void SetZoom(object sender, EventArgs e) { report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass); CodeHelper.UI.MessageDialog<NumericUpDown> mesDialog = new MessageDialog<NumericUpDown>("Масштаб", "Масштаб (25-400%):", ""); mesDialog[0].Minimum = 25; mesDialog[0].Maximum = 400; switch (mesDialog.ShowDialog()) { case DialogResult.OK: Zoom((int)mesDialog[0].Value); break; default: break; } }
/// <summary> /// Select report from the list. /// </summary> public static CrystalDecisions.CrystalReports.Engine.ReportClass SelectReport(int subModuleId) { CrystalDecisions.CrystalReports.Engine.ReportClass currentReport = new CrystalDecisions.CrystalReports.Engine.ReportClass(); switch (subModuleId) { #region ECB report case 10: //ECB_DetailReport { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_DetailReport(); break; } case 11: //ECB_CallDetailReport report { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_CallDetailReport(); break; } case 30: //ECB Audit Edtail report { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_AuditDetail(); break; } case 31: //ECB_VendalDetail { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ECB_VendalDetail(); break; } #endregion #region MET report case 13: //Consolidate revenue report { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.MET_Hourly_Data_Report(); break; } case 15: //Consolidate revenue report { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.MET_Daily_Data_Report(); break; } #endregion #region ATCC report case 25: { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_DetailReport(); break; } case 26: { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_TransactionDetailReport(); break; } case 27: { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_MonthlyTrafficCount(); break; } case 28: { currentReport = new VaaaN.MLFF.Libraries.ReportLibrary.CrystalReports.ATCC_HourlyTrafficCount(); break; } #endregion #region vMS #endregion #region CCTV #endregion default: break; } return(currentReport); }
public Imprimir(CrystalDecisions.CrystalReports.Engine.ReportClass r) { InitializeComponent(); this.crystalReportViewer1.ReportSource = r; }
void goToPageButton_MouseDown(object sender, MouseEventArgs e) { report = (ReportSource as CrystalDecisions.CrystalReports.Engine.ReportClass); CodeHelper.UI.MessageDialog<NumericUpDown> mesDialog = new MessageDialog<NumericUpDown>("Переход на страницу", "Перейти на сраницу №:", ""); mesDialog[0].Minimum = 1; switch (mesDialog.ShowDialog()) { case DialogResult.OK: ShowNthPage((int)mesDialog[0].Value); break; default: break; } }
public bool Export(CrystalDecisions.CrystalReports.Engine.ReportClass report, string path, TypeBC type) { if (report == null) { return(false); } switch (type) { case TypeBC.WordForWindows: { int index = path.LastIndexOf('.'); if (index > 0) { if (path.Substring(index + 1).ToLower().Equals("doc")) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path); } else if (index == path.Length - 1) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + "doc"); } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + ".doc"); } } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, path + ".doc"); } break; } case TypeBC.Excel: { int index = path.LastIndexOf('.'); if (index > 0) { if (path.Substring(index + 1).ToLower().Equals("xls")) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path); } else if (index == path.Length - 1) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + "xls"); } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + ".xls"); } } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, path + ".xls"); } break; } case TypeBC.PortableDocFormat: { int index = path.LastIndexOf('.'); if (index > 0) { if (path.Substring(index + 1).ToLower().Equals("pdf")) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); } else if (index == path.Length - 1) { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + "pdf"); } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + ".pdf"); } } else { report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path + ".pdf"); } break; } } return(true); }