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);
}
}
}
