public void showsales(string datefrom, string dateto, string user, DataGridView dvg) { CTU_BARCODE_READER.REPORT.DataSet1 ds = new CTU_BARCODE_READER.REPORT.DataSet1(); DataTable dt = ds.Tables["Sales"]; txtsalesdatefrom = (TextObject)s.ReportDefinition.Sections["PageHeaderSection2"].ReportObjects["datefrom"]; txtsalesdateto = (TextObject)s.ReportDefinition.Sections["PageHeaderSection2"].ReportObjects["dateto"]; txtuser = (TextObject)s.ReportDefinition.Sections["PageHeaderSection3"].ReportObjects["txtuser"]; txtsalesdatefrom.Text = datefrom; txtsalesdateto.Text = dateto; txtuser.Text = user; DataRow r; int i = 0; for (i = 0; i < dvg.Rows.Count; i++) { r = dt.NewRow(); r["Date"] = dvg.Rows[i].Cells[0].Value.ToString(); r["Description"] = dvg.Rows[i].Cells[3].Value.ToString(); r["Amount"] = dvg.Rows[i].Cells[2].Value.ToString(); dt.Rows.Add(r); } s.SetDataSource(ds.Tables[2]); cr.ReportSource = s; cr.Refresh(); f.ShowDialog(); }
public Report1(string korisnik) { this.korisnik = korisnik; InitializeComponent(); CrystalReportViewer reportViewer = new CrystalReportViewer(); this.Controls.Add(reportViewer); reportViewer.Dock = DockStyle.Fill; if (korisnik == "iznajmljivanje") { var rpt = new ReportDocument(); string reportPath = @"../../../IzvjestajIznajmljivanje.rpt"; rpt.Load(reportPath); reportViewer.ReportSource = rpt; reportViewer.Refresh(); } else if (korisnik == "blagajnik") { var rpt2 = new ReportDocument(); string reportPath2 = @"../../../FinansijskiIzvjestaj.rpt"; rpt2.Load(reportPath2); reportViewer.ReportSource = rpt2; reportViewer.Refresh(); } else if (korisnik == "Knjige") { var rpt3 = new ReportDocument(); string reportPath3 = @"../../../PregledKnjiga.rpt"; rpt3.Load(reportPath3); reportViewer.ReportSource = rpt3; reportViewer.Refresh(); } else if (korisnik == "blagajnikIzvjestaj") { var rpt4 = new ReportDocument(); string reportPath4 = @"../../../rptNaplataClanarine.rpt"; rpt4.Load(reportPath4); reportViewer.ReportSource = rpt4; reportViewer.Refresh(); } }
private void LoadReport() { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(Application.StartupPath + "\\Reports\\TopMeters.rpt"); CrystalReportViewer.ReportSource = cryRpt; CrystalReportViewer.Refresh(); }
private void btnPrintReport_Click(object sender, EventArgs e) { try { DataTable data = (DataTable)(gridReportList.DataSource); DataTable headerTable = new DataTable("Customers"); DataColumn dtColumn; DataRow myDataRow; dtColumn = new DataColumn(); dtColumn.DataType = typeof(String); dtColumn.ColumnName = "COMPANY_NAME"; headerTable.Columns.Add(dtColumn); dtColumn = new DataColumn(); dtColumn.DataType = typeof(String); dtColumn.ColumnName = "USER_PRINT"; headerTable.Columns.Add(dtColumn); myDataRow = headerTable.NewRow(); myDataRow["COMPANY_NAME"] = "BIG Visitor Management"; myDataRow["USER_PRINT"] = LOGIN; headerTable.Rows.Add(myDataRow); ReportDocument rpt = new ReportDocument(); string path = System.Reflection.Assembly.GetExecutingAssembly().Location; var appPath = Application.StartupPath + "\\" + "VisitorListReport.rpt"; rpt.Load(appPath); rpt.Database.Tables[0].SetDataSource(data); rpt.Database.Tables[1].SetDataSource(headerTable); using (Form form = new Form()) { CrystalReportViewer tempViewer = new CrystalReportViewer(); tempViewer.ActiveViewIndex = -1; tempViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; tempViewer.Dock = System.Windows.Forms.DockStyle.Fill; tempViewer.Name = "tempViewer"; tempViewer.SelectionFormula = ""; tempViewer.TabIndex = 0; tempViewer.ViewTimeSelectionFormula = ""; tempViewer.ReportSource = rpt; tempViewer.AutoSize = true; tempViewer.Refresh(); form.Controls.Add(tempViewer); form.Size = this.Size; form.StartPosition = FormStartPosition.CenterParent; form.ShowDialog(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public override void Window_Loaded(object sender, RoutedEventArgs e) { this.WindowState = WindowState.Maximized; if (articleList != null) { dt = GlobalFunctions.ListToDataTable(articleList); } if (crystalReportViewer == null || reportDocument == null) { return; } crystalReportViewer.Refresh(); reportDocument.Refresh(); reportDocument.SetDataSource(dt); SetParameterValues(); crystalReportViewer.ReportSource = reportDocument; crystalReportViewer.Refresh(); reportDocument.Refresh(); }
public Report(string korisnik) { this.korisnik = korisnik; InitializeComponent(); CrystalReportViewer reportViewer = new CrystalReportViewer(); this.Controls.Add(reportViewer); reportViewer.Dock = DockStyle.Fill; if (korisnik == "iznajmljivanje") { var rpt = new ReportDocument(); string reportPath = @"C:\Users\vladimir.klisura\Desktop\IzvjestajIznajmljivanje.rpt"; rpt.Load(reportPath); reportViewer.ReportSource = rpt; reportViewer.Refresh(); } else if (korisnik == "blagajnik") { var rpt2 = new ReportDocument(); string reportPath2 = @"C:\Users\vladimir.klisura\Desktop\FinansijskiIzvjestaj.rpt"; rpt2.Load(reportPath2); reportViewer.ReportSource = rpt2; reportViewer.Refresh(); } else if (korisnik == "Knjige") { var rpt3 = new ReportDocument(); string reportPath3 = @"C:\Users\vladimir.klisura\Desktop\PregledKnjiga.rpt"; rpt3.Load(reportPath3); reportViewer.ReportSource = rpt3; reportViewer.Refresh(); } }
public tstfrm1() { InitializeComponent(); ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(@"C:\CrystalReport1.rpt"); CrystalReportViewer crystalReportViewer1 = new CrystalReportViewer(); crystalReportViewer1.ReportSource = rptDoc; crystalReportViewer1.Refresh(); this.Controls.Add(crystalReportViewer1); crystalReportViewer1.Dock = DockStyle.Fill; }
public void ShowHDNoView(int ma) { DataTable dt = new DataTable(); if (ma == 0) // DataSet ds = new DataSet(); dt = tXuat.GetDataHD(maHD); else dt = tXuat.GetDataHD(ma); // ds.Tables.Add(dt); rptHD rpt = new rptHD(); rpt.SetDataSource(dt); CrystalReportViewer rptview = new CrystalReportViewer(); rptview.ReportSource = rpt; rptview.Refresh(); rptview.PrintReport(); }
public tstfrm1() { InitializeComponent(); ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(@"C:\CrystalReport1.rpt"); /*If you have a datasource, link it like below*/ //rptDoc.SetDataSource(dataset.Tables["tripsheet"]); CrystalReportViewer crystalReportViewer1 = new CrystalReportViewer(); crystalReportViewer1.ReportSource = rptDoc; crystalReportViewer1.Refresh(); this.Controls.Add(crystalReportViewer1); crystalReportViewer1.Dock = DockStyle.Fill; }
public void ShowHDNoView(int ma) { DataTable dt = new DataTable(); if (ma == 0) { // DataSet ds = new DataSet(); dt = tXuat.GetDataHD(maHD); } else { dt = tXuat.GetDataHD(ma); } // ds.Tables.Add(dt); rptHD rpt = new rptHD(); rpt.SetDataSource(dt); CrystalReportViewer rptview = new CrystalReportViewer(); rptview.ReportSource = rpt; rptview.Refresh(); rptview.PrintReport(); }
private void btnPrintMonth_Click(object sender, EventArgs e) { var timeNow = DateTime.Now; var firstDayOfMonth = new DateTime(timeNow.Year, timeNow.Month, 1); var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); var filter = new VisitorFilter() { DATE_FROM = ChangeTime(firstDayOfMonth, 0, 0, 0, 1), DATE_TO = ChangeTime(lastDayOfMonth, 23, 59, 59, 59), }; _container.Filter = filter; _container = _service.GetVisitorForReport(_container); if (_container.ResultObj.Count > 0) { List <CustomVisitor> listData = (List <CustomVisitor>)_container.ResultObj; DataTable dt = ConvertToDataTable(listData); DataTable headerTable = new DataTable("Customers"); DataColumn dtColumn; DataRow myDataRow; dtColumn = new DataColumn(); dtColumn.DataType = typeof(String); dtColumn.ColumnName = "COMPANY_NAME"; headerTable.Columns.Add(dtColumn); dtColumn = new DataColumn(); dtColumn.DataType = typeof(String); dtColumn.ColumnName = "USER_PRINT"; headerTable.Columns.Add(dtColumn); myDataRow = headerTable.NewRow(); myDataRow["COMPANY_NAME"] = "BIG Visitor Management"; myDataRow["USER_PRINT"] = LOGIN; headerTable.Rows.Add(myDataRow); ReportDocument rpt = new ReportDocument(); string path = System.Reflection.Assembly.GetExecutingAssembly().Location; var appPath = Application.StartupPath + "\\" + "VisitorListReport.rpt"; rpt.Load(appPath); rpt.Database.Tables[0].SetDataSource(dt); rpt.Database.Tables[1].SetDataSource(headerTable); using (Form form = new Form()) { CrystalReportViewer tempViewer = new CrystalReportViewer(); tempViewer.ActiveViewIndex = -1; tempViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; tempViewer.Dock = System.Windows.Forms.DockStyle.Fill; tempViewer.Name = "tempViewer"; tempViewer.SelectionFormula = ""; tempViewer.TabIndex = 0; tempViewer.ViewTimeSelectionFormula = ""; tempViewer.ReportSource = rpt; tempViewer.AutoSize = true; tempViewer.Refresh(); form.Controls.Add(tempViewer); form.Size = this.Size; form.StartPosition = FormStartPosition.CenterParent; form.ShowDialog(); } } SetDataSourceHeader(gridReportList, ListHeader(), _container.ResultObj); }
private void MostrarNotaTerminacion(string numeroPedido) { crystalReportViewer1.ReportSource = GenerarNotaTerminacion(numeroPedido); crystalReportViewer1.Refresh(); }
public void ShowReport(CrystalReportViewer rptView, DataSet ds, int tblIndex, string path, string sSelectionFormula, ArrayList lstParam = null, ArrayList paramName = null) { //CrystalDecisions.CrystalReports.Engine.ReportDocument obj = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); int pCount; ParameterFields paramFields = new ParameterFields(); try { objReport = new ReportDocument(); objReport.Load(Application.StartupPath + "\\Report\\RptBom.Rpt"); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = path; crConnectionInfo.DatabaseName = path; crConnectionInfo.UserID = ""; crConnectionInfo.Password = ""; CrTables = objReport.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (lstParam != null) { pCount = lstParam.Count; for (int i = 0; i < pCount; i++) { ParameterField paramField = new ParameterField(); ParameterDiscreteValue discreteVal = new ParameterDiscreteValue(); paramField.ParameterFieldName = paramName[i].ToString(); // Set the discrete value and pass it to the parameter discreteVal.Value = lstParam[i].ToString(); paramField.CurrentValues.Add(discreteVal); // Add parameter to the parameter fields collection. paramFields.Add(paramField); } } if (sSelectionFormula.Length > 0) { objReport.RecordSelectionFormula = sSelectionFormula; } rptView.ReportSource = null; rptView.ParameterFieldInfo = paramFields; rptView.ReuseParameterValuesOnRefresh = true; rptView.ReportSource = objReport; for (int i = 0; i < rptView.LogOnInfo.Count; i++) { rptView.LogOnInfo[i].ConnectionInfo = crConnectionInfo; } rptView.Refresh(); rptView.Show(); //objReport.Database.Dispose(); //objReport.Dispose(); //objReport.Close(); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } finally { //objReport.Database.Dispose(); //objReport.Dispose(); //objReport.Close(); //paramFields = null; } }
private void rbtn7_Click(object sender, EventArgs e) { rpnl4.Visible = true; rpnl3.Visible = false; DateTime x = DateTime.Now; String date = x.ToString("yyyy-MM-dd"); //String date = "2014-11-02"; String cm = ""; if (type.CompareTo("all") == 0) { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "'; "; } else if (type.CompareTo("takeaway") == 0) { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; "; } else if (type.CompareTo("dine") == 0) { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; "; } else if (type.CompareTo("delivery") == 0) { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; "; } else if (type.CompareTo("category") == 0) { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemcateg = '" + rcmb1.SelectedItem.ToString() + "'; "; } else if (type == "item") { String selitem = rcmb1.SelectedItem.ToString(); int siz = 0; if (selitem.Contains(" 8")) { siz = 8; selitem = selitem.Replace(" 8", ""); cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "' and itemsize = " + siz + "; "; } else if (selitem.Contains(" 12")) { siz = 12; selitem = selitem.Replace(" 12", ""); cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "' and itemsize = " + siz + "; "; } else { cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "'; "; } } SqlCommand cmd = new SqlCommand(cm, con); con.Open(); //MessageBox.Show(cm); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); todayreport obj = new todayreport(); obj.SetDataSource(dt); crystalReportViewer1.ReportSource = obj; crystalReportViewer1.Size = new Size(2000, 2000); crystalReportViewer1.Refresh(); rpnl4.Controls.Add(crystalReportViewer1); con.Close(); }
private void MostrarFormaPedido(string clavePedido) { crystalReportViewer1.ReportSource = ManejadorContabilidad.GenerarFormaPedido(clavePedido); crystalReportViewer1.Refresh(); }