public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TSLbarcodes rpt = new TSLbarcodes(); rpt.Site = this.Site; return(rpt); }
private void Printbarcode() { { // var objReport = default(object); var objCrTableLogOnInfo = new TableLogOnInfo(); var objCrConnectionIno = new ConnectionInfo(); Database ObjCrDtabase; Tables ObjCrTables; string strSelectionFormula; var rptViewer = new rtpviewreport(); strSelectionFormula = " {Products.ID}=" + lbltrid.Text + ""; var objRepShow = new rtpviewreport(); TSLbarcodes objReport = new TSLbarcodes(); try { { objReport = new TSLbarcodes(); } objCrConnectionIno.ServerName = Properties.Settings.Default.DSN; // MYSMS_SYSTEM.My.Settings.SERVERNAME ' "MYSMS" objCrConnectionIno.UserID = Properties.Settings.Default.UserName; // MYSMS_SYSTEM.My.Settings.USER_NAME objCrConnectionIno.Password = Properties.Settings.Default.Password; // MYSMS_SYSTEM.My.Settings.PASSWORD ObjCrDtabase = objReport.Database; // = .GetDatabase() ObjCrTables = ObjCrDtabase.Tables; strSelectionFormula = ""; strSelectionFormula = " {Products.ID}=" + lbltrid.Text + ""; // and cdate({LEAVE_APPLICATION_TB.LEAVE_START_DATE})>= #" & CDate(From_date) & "# " foreach (Table objCrTable in ObjCrTables) { objCrTableLogOnInfo = objCrTable.LogOnInfo; objCrTableLogOnInfo.ConnectionInfo = objCrConnectionIno; objCrTable.ApplyLogOnInfo(objCrTableLogOnInfo); } objRepShow.CrystalReportViewer1.PrintReport(); { var withBlock = objRepShow.CrystalReportViewer1; withBlock.ReportSource = objReport; withBlock.SelectionFormula = strSelectionFormula; withBlock.Dock = DockStyle.Fill; withBlock.ShowGroupTreeButton = false; // .DisplayGroupTree = False withBlock.ShowFirstPage(); objRepShow.CrystalReportViewer1.RefreshReport(); } objRepShow.Refresh(); objRepShow.BringToFront(); objRepShow.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }