public void setLogonInfo(ReportDocument reportDoc)
{
if (!reportDoc.IsSubreport)
{
foreach (ReportDocument rptSubDoc in reportDoc.Subreports)
{
setLogonInfo(rptSubDoc);
}
}
CrystalDecisions.Shared.ConnectionInfo conInfo = new CrystalDecisions.Shared.ConnectionInfo();
/* conInfo.ServerName = "202.45.144.159";//ConfigurationManager.AppSettings["DBServer"];
* conInfo.UserID = "mis"; //ConfigurationManager.AppSettings["DBUserID"];
* conInfo.Password = "******";// ConfigurationManager.AppSettings["DBPassword"];
* conInfo.DatabaseName = "ORCLDATABASE"; //ConfigurationManager.AppSettings["DBNAME"];*/
conInfo.ServerName = "wbrs"; //ConfigurationManager.AppSettings["DBServer"];
conInfo.UserID = "MIS"; //ConfigurationManager.AppSettings["DBUserID"];
conInfo.Password = "******"; // ConfigurationManager.AppSettings["DBPassword"];
//conInfo.DatabaseName = "ORCLDATABASE"; //ConfigurationManager.AppSettings["DBNAME"];
//conInfo.IntegratedSecurity = false;
foreach (CrystalDecisions.CrystalReports.Engine.Table tb in reportDoc.Database.Tables)
{
CrystalDecisions.Shared.TableLogOnInfo tblInfo = tb.LogOnInfo;
tblInfo.ConnectionInfo = conInfo;
tb.ApplyLogOnInfo(tblInfo);
}
}
void customConn()
{
CrystalDecisions.Shared.ConnectionInfo myConnectionInfo =
new CrystalDecisions.Shared.ConnectionInfo();
myConnectionInfo.DatabaseName = "_smuclinic";
myConnectionInfo.UserID = "smuclinic";
myConnectionInfo.Password = "******";
}
private void LoadReportTest2()
{
CrystalDecisions.CrystalReports.Engine.ReportDocument doc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
doc.Load(@"C:\CrystalReport1.rpt");
this.CrystalReportViewer1.ReportSource = doc;
this.CrystalReportViewer1.HasSearchButton = false;
this.CrystalReportViewer1.HasZoomFactorList = false;
this.CrystalReportViewer1.HasGotoPageButton = false;
/*
*
* CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition fieldDef=doc.DataDefinition.ParameterFields["ids_param"];
* CrystalDecisions.Shared.ParameterValues vals=new CrystalDecisions.Shared.ParameterValues();
*
* CrystalDecisions.Shared.ParameterDiscreteValue val=new CrystalDecisions.Shared.ParameterDiscreteValue();
* val.Value=1;
* vals.Add(val);
*
* val=new CrystalDecisions.Shared.ParameterDiscreteValue();
* val.Value=2;
* vals.Add(val);
*
* val=new CrystalDecisions.Shared.ParameterDiscreteValue();
* val.Value=3;
* vals.Add(val);
*
* fieldDef.ApplyCurrentValues(vals);
*
*
*
* string connString=@"Server=.;Database=DBSALESPP;User ID=spp;Password=spp";
* System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter("select * from olap_log" , connString);
* System.Data.DataSet dataSet=new DataSet();
* adapter.Fill(dataSet);
* doc.SetDataSource(dataSet);
*/
CrystalDecisions.Shared.ConnectionInfo conn = new CrystalDecisions.Shared.ConnectionInfo();
conn.DatabaseName = "DBSALESPP";
conn.UserID = "spp";
conn.Password = "******";
CrystalDecisions.Shared.TableLogOnInfo tableLogOn = new CrystalDecisions.Shared.TableLogOnInfo();
tableLogOn.ConnectionInfo = conn;
for (int i = 0; i < doc.Database.Tables.Count; i++)
{
doc.Database.Tables[i].ApplyLogOnInfo(tableLogOn);
}
//System.IO.Stream stream=doc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.HTML32);
//doc.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat , @"c:\test.pdf");
}
static void InitializeTables(ConnectionInfo connectionInfo, ReportDocument reportDocument)
{
var tables = reportDocument.Database.Tables;
foreach (Table table in tables)
{
var logonInfo = table.LogOnInfo;
logonInfo.ConnectionInfo = connectionInfo;
table.ApplyLogOnInfo(logonInfo);
}
}
public static CrystalDecisions.Shared.ConnectionInfo GetConnectionInfo()
{
var Sconn = new System.Data.SqlClient.SqlConnectionStringBuilder(
System.Configuration.ConfigurationManager.ConnectionStrings["ProyectosConnection"].ConnectionString);
CrystalDecisions.Shared.ConnectionInfo connInfo = new CrystalDecisions.Shared.ConnectionInfo();
connInfo.ServerName = Sconn.DataSource;
connInfo.DatabaseName = Sconn.InitialCatalog;
connInfo.UserID = Sconn.UserID;
connInfo.Password = Sconn.Password;
return(connInfo);
}
public MainWindow()
{
InitializeComponent();
cbExternal.DataContext = ReportInfos;
cbReport.DataContext = ReportInfos;
_connectionInfo = new ConnectionInfo
{
ServerName = @".\SQLEXPRESS",
DatabaseName = "NHibernateSketches",
IntegratedSecurity = true
};
}
public void GenerateReport()
{
try
{
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions crParameterFieldDefinitions;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition crParameterFieldDefinition;
CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
objReport1.Load(LoadReport());
string sUserID = "sa";
string sPassword = "******";
string sServerName = "192.168.1.42";
string sDatabaseName = "BoxControlAndMonitoringDB";
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
//crConnectionInfo.IntegratedSecurity = true;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport1.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
reportViewer.ViewerCore.ReportSource = objReport1;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void LoadReportTest1()
{
CrystalDecisions.CrystalReports.Engine.ReportDocument doc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
doc.Load(@"C:\test1.rpt");
this.CrystalReportViewer1.ReportSource = doc;
this.CrystalReportViewer1.HasSearchButton = false;
this.CrystalReportViewer1.HasZoomFactorList = false;
this.CrystalReportViewer1.HasGotoPageButton = false;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition fieldDef = doc.DataDefinition.ParameterFields["ids_param"];
CrystalDecisions.Shared.ParameterValues vals = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue val = new CrystalDecisions.Shared.ParameterDiscreteValue();
val.Value = 1;
vals.Add(val);
val = new CrystalDecisions.Shared.ParameterDiscreteValue();
val.Value = 2;
vals.Add(val);
val = new CrystalDecisions.Shared.ParameterDiscreteValue();
val.Value = 3;
vals.Add(val);
fieldDef.ApplyCurrentValues(vals);
CrystalDecisions.Shared.ConnectionInfo conn = new CrystalDecisions.Shared.ConnectionInfo();
conn.DatabaseName = "DBSALESPP";
conn.ServerName = ".";
conn.UserID = "spp";
conn.Password = "******";
CrystalDecisions.Shared.TableLogOnInfo tableLogOn = new CrystalDecisions.Shared.TableLogOnInfo();
tableLogOn.ConnectionInfo = conn;
doc.Database.Tables[0].ApplyLogOnInfo(tableLogOn);
//System.IO.Stream stream=doc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.HTML32);
doc.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @"c:\test.pdf");
}
protected void Page_Load(object sender, EventArgs e)
{
//string foldername = Server.MapPath("~/CS_REPORT/rpt/cmperaccount.rpt");
try
{
string strpath = MapPath("~/CS_REPORT/rpt/cmperaccount.rpt");
//string strpath = Server.MapPath("~/CS_REPORT/rpt/ftmandytdsellinperareareport.rpt");
ReportDocument report = new ReportDocument();
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtableLogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
Tables CrTables;
CrystalReportSource1.Report.FileName = strpath;
report.Load(strpath);
crConnectionInfo.ServerName = "192.168.10.15";
crConnectionInfo.DatabaseName = "MATIMCO";
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
CrTables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
CrystalReportViewer1.ReportSource = report;
CrystalReportViewer1.RefreshReport();
Label2.Text = CrystalReportViewer1.ParameterFieldInfo[0].Name + "-" + CrystalReportViewer1.ParameterFieldInfo[1].Name;
}
catch (Exception ex)
{
Label2.Text = "Error-" + ex.Message;
}
}
public static void LogonReport(CrystalDecisions.CrystalReports.Engine.ReportDocument reportdocument)
{
System.Data.SqlClient.SqlConnectionStringBuilder con = new System.Data.SqlClient.SqlConnectionStringBuilder();
con.ConnectionString = ConfigurationManager.ConnectionStrings["SPDDevConnectionString"].ConnectionString;
CrystalDecisions.Shared.ConnectionInfo consinfo = new CrystalDecisions.Shared.ConnectionInfo();
consinfo.ServerName = con.DataSource;
consinfo.UserID = con.UserID;
consinfo.DatabaseName = con.InitialCatalog;
consinfo.Password = con.Password;
consinfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL;
CrystalDecisions.CrystalReports.Engine.Tables myTables = reportdocument.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in myTables)
{
CrystalDecisions.Shared.TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo;
myTableLogonInfo.ConnectionInfo = consinfo;
myTable.ApplyLogOnInfo(myTableLogonInfo);
}
}
private void print_Report(int idx)
{
string crt;
string rep_path;
bool fnd = false;
try
{
ReportDocument CrRep = new ReportDocument();
rep_path = "";
crt = "";
switch (idx)
{
case 1:
{
//crt = "{Reciepts.Reciept_no} =" + Convert.ToDouble(Txtitem.Text);
rep_path = Gvar.report_path + "\\reports\\ItemMasterN.rpt";
CrRep.Load(rep_path);
CrRep.SummaryInfo.ReportTitle = "Material Stock Report for all";
}
break;
}
//crconnectioninfo.ServerName = "Mujeeb";
//crconnectioninfo.DatabaseName = "Printex";
//crconnectioninfo.UserID = "sa";
//crconnectioninfo.Password = "******";
//CrRep.PrintOptions.PaperSize= CrystalDecisions.Shared.PaperSize.PaperEnvelope10;
if (crt != "")
{
CrRep.RecordSelectionFormula = crt;
}
CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
Tables CrTables;
crconnectioninfo.ServerName = decoder.DataSource;
crconnectioninfo.DatabaseName = decoder.InitialCatalog;
crconnectioninfo.UserID = decoder.UserID;
crconnectioninfo.Password = decoder.Password;
CrTables = CrRep.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtablelogoninfo = CrTable.LogOnInfo;
crtablelogoninfo.ConnectionInfo = crconnectioninfo;
CrTable.ApplyLogOnInfo(crtablelogoninfo);
}
//CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, decoder.DataSource, decoder.InitialCatalog);
//CrRep.Load();
//CrRep.ReadRecords();
//CrRep.Refresh();
//if (chkprinter.Checked)
//{
// CrRep.PrintToPrinter(1, true, 0, 0);
//}
//else
//{
FrmrepView frm = new FrmrepView();
frm.MdiParent = this.ParentForm;
frm.crv1.ReportSource = CrRep;
frm.Show();
//}
//ConnectionInfo connInfo = new ConnectionInfo();
//connInfo.ServerName = "dbservername";
//connInfo.DatabaseName = "dbname";
//connInfo.UserID = "dbusername";
//connInfo.Password = "******";
//reportViewer.ReportSource = GetReportSource(connInfo);
CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, "Mujeeb", decoder.InitialCatalog);
//CrRep.Load();
// CrRep.ReadRecords();
//CrRep.Refresh();
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
}
}
private void btnView_Click(object sender, EventArgs e)
{
try
{
ReportDocument CrRep = new ReportDocument();
CRT2 = "";
CRT3 = "";
fnd = false;
DateTime edt1 = dt1.Value;
DateTime edt2 = dt2.Value;;
// string sdt2 = string.Format("yyyy,MM,dd,00,00,00", Gvar.ArCalendar(dt2.Value, true));
string adate1 = dt1.Value.Date.ToString("dd-MM-yyyy");
string adate2 = dt2.Value.Date.ToString("dd-MM-yyyy");
string sdt1 = edt1.Date.ToString("yyyy,MM,dd,00,00,00");
string sdt2 = edt2.Date.ToString("yyyy,MM,dd,23,59,59");
string hd3;
hd3 = "'Report'";
crt1 = "";
switch (Gvar._Gind)
{
case 1:
{
rep_path = Gvar.report_path + "\\reports\\RepProject.rpt";
CrRep.Load(rep_path);
//DateTime edt1 = Convert.ToDateTime(Gvar.ArCalendar(dt1.Value, true,false));
//DateTime edt2 = Convert.ToDateTime(Gvar.ArCalendar(dt2.Value, true,false));
goto nxt;
string rdt1 = dt1.Value.ToString("dd/MM/yyyy");
string rdt2 = dt2.Value.ToString("dd/MM/yyyy");
if (!chkdate.Checked)
{
crt1 = " {TRN_ACCOUNTS.PAY_DATE} in DateTime (" + sdt1 + ") to DateTime (" + sdt2 + ")";
RPTHEAD = "Account Summary From " + rdt1 + " To " + rdt2;
}
else
{
RPTHEAD = "Account Summary Report for All Dates";
crt1 = "";
}
//crt1 = crt1 + " And ({QRY_ITEM.TRN_TYPE} = 2 Or {QRY_ITEM.TRN_TYPE} =8)";
string crt2 = "";
if (cmbowner.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt2 = "{accounts.acc_type_code} = " + cmbowner.SelectedValue;
RPTHEAD = RPTHEAD + " for Type " + cmbowner.Text;
}
fnd = false;
string crt4 = "";
lst1.EndEdit();
int i = 0;
if (chklst1.Checked)
{
//crt4 = "{accounts.acc_no} <> -1";
fnd = true;
}
else
{
for (i = 0; i < lst1.RowCount; i++)
{
if (lst1[0, i].Value != null)
{
if ((bool)lst1[0, i].Value)
{
if (crt4 == "")
{
crt4 = lst1[2, i].Value.ToString();
}
else
{
crt4 = crt4 + "," + lst1[2, i].Value.ToString();
}
fnd = true;
}
}
}
crt4 = "{accounts.acc_no} in [" + crt4 + "]";
RPTHEAD = RPTHEAD + ", for Accounts " + crt4;
}
if (!fnd)
{
MessageBox.Show("There is No Accounts selected, Please Try AGain", "Wrong Selection");
return;
}
fnd = false;
string crt3 = "";
lst2.EndEdit();
//if (chklst2.Checked)
//{
// // crt3 = "{accounts.acc_no} <> -1";
// fnd = true;
//}
//else
//{
// for (i = 0; i < lst2.RowCount; i++)
// {
// if (lst2[0, i].Value != null)
// {
// if ((bool)lst2[0, i].Value)
// {
// if (crt3 == "")
// {
// crt3 = lst2[1, i].Value.ToString();
// }
// else
// {
// crt3 = crt3 + "," + lst2[1, i].Value.ToString();
// }
// fnd = true;
// }
// }
// }
// crt3 = "{TRN_accounts.acc_no} in [" + crt3 + "]";
//}
//if (!fnd)
//{
// MessageBox.Show("There is No Account selected, Please Try Again", "Wrong Vehicle Selection");
// return;
//}
string crt5 = "";
if (cmbsaleagent.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt5 = "{accounts.account_link} = " + cmbsaleagent.SelectedValue;
RPTHEAD = RPTHEAD + " for Saleagent " + cmbsaleagent.Text;
}
string crt6 = "";
if (cmblocaltion.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt6 = "{accounts_info.area_name} = '" + cmblocaltion.Text + "'";
RPTHEAD = RPTHEAD + " for Area " + cmblocaltion.Text;
}
string crt = "";
if (crt1 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt1;
}
else
{
crt = crt1;
}
}
if (crt2 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt2;
}
else
{
crt = crt2;
}
}
if (crt3 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt3;
}
else
{
crt = crt3;
}
}
// if (crt3 != "") crt = crt + " aND " + crt3;
//if (crt4 != "") crt = crt + " aND " + crt4;
//crt = crt + " aND " + crt4 + " AND {DATA_ENTRY.TRN_TYPE} = 7";
if (crt4 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt4;
}
else
{
crt = crt4;
}
}
if (crt5 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt5;
}
else
{
crt = crt5;
}
}
if (crt6 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt6;
}
else
{
crt = crt6;
}
}
//if (crt1 != "") crt2 = crt1 + " And " + crt2;
rep_formula = crt; // 2 + " aND " + crt3 + " aND " + crt4;// +" AND {QRY_ITEM.QTY}<>0";
CrRep.SummaryInfo.ReportTitle = RPTHEAD; // "Account Detail Report from " + rdt1 + " To " + rdt2;
if (cmbtransaction.SelectedIndex == 1)
{
if (crt == "")
{
rep_formula = "{TRN_accounts.DR_CR}='D'";
}
else
{
rep_formula = crt + " AND {TRN_accounts.DR_CR}='D'";
}
CrRep.SummaryInfo.ReportTitle = RPTHEAD + " , FOR " + cmbtransaction.Text;
}
if (cmbtransaction.SelectedIndex == 2)
{
if (crt == "")
{
rep_formula = "{TRN_accounts.DR_CR}='C'";
}
else
{
rep_formula = crt + " AND {TRN_accounts.DR_CR}='C'";
}
CrRep.SummaryInfo.ReportTitle = RPTHEAD + " , FOR " + cmbtransaction.Text;
}
nxt :;
}
break;
case 2:
{
rep_path = Gvar.report_path + "\\reports\\repacctrans.rpt";
CrRep.Load(rep_path);
//DateTime edt1 = Convert.ToDateTime(Gvar.ArCalendar(dt1.Value, true,false));
//DateTime edt2 = Convert.ToDateTime(Gvar.ArCalendar(dt2.Value, true,false));
string rdt1 = dt1.Value.ToString("dd/MM/yyyy");
string rdt2 = dt2.Value.ToString("dd/MM/yyyy");
if (!chkdate.Checked)
{
crt1 = " {TRN_ACCOUNTS.PAY_DATE} in DateTime (" + sdt1 + ") to DateTime (" + sdt2 + ")";
RPTHEAD = "Account Detail From " + rdt1 + " To " + rdt2;
}
else
{
RPTHEAD = "Accounts Detail Report for All Date ";
}
//crt1 = crt1 + " And ({QRY_ITEM.TRN_TYPE} = 2 Or {QRY_ITEM.TRN_TYPE} =8)";
string crt2 = "";
if (cmbowner.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt2 = "{accounts.acc_type_code} = " + cmbowner.SelectedValue;
RPTHEAD = RPTHEAD + ", for Type " + cmbowner.Text;
}
fnd = false;
string crt4 = "";
lst1.EndEdit();
int i = 0;
if (chklst1.Checked)
{
//crt4 = "{accounts.acc_no} <> -1";
fnd = true;
}
else
{
for (i = 0; i < lst1.RowCount; i++)
{
if (lst1[0, i].Value != null)
{
if ((bool)lst1[0, i].Value)
{
if (crt4 == "")
{
crt4 = lst1[2, i].Value.ToString();
}
else
{
crt4 = crt4 + "," + lst1[2, i].Value.ToString();
}
fnd = true;
}
}
}
crt4 = "{accounts.acc_no} in [" + crt4 + "]";
}
if (!fnd)
{
MessageBox.Show("There is No Accounts selected, Please Try AGain", "Wrong Selection");
return;
}
fnd = false;
string crt3 = "";
lst2.EndEdit();
//if (chklst2.Checked)
//{
// //crt3 = "{accounts.acc_no} <> -1";
// fnd = true;
//}
//else
//{
// for (i = 0; i < lst2.RowCount; i++)
// {
// if (lst2[0, i].Value != null)
// {
// if ((bool)lst2[0, i].Value)
// {
// if (crt3 == "")
// {
// crt3 = lst2[1, i].Value.ToString() ;
// }
// else
// {
// crt3 = crt3 + "," + lst2[1, i].Value.ToString();
// }
// fnd = true;
// }
// }
// }
// crt3 = "{TRN_accounts.acc_no} in [" + crt3 + "]";
//}
//if (!fnd)
//{
// MessageBox.Show("There is No vehicle selected, Please Try Again", "Wrong Vehicle Selection");
// return;
//}
string crt5 = "";
if (cmbsaleagent.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt5 = "{accounts.account_link} = " + cmbsaleagent.SelectedValue;
RPTHEAD = RPTHEAD + " for Saleagent " + cmbsaleagent.Text;
}
string crt6 = "";
if (cmblocaltion.SelectedIndex < 1)
{
// crt2 = "{accounts.acc_type_code} <> -1";
}
else
{
crt6 = "{accounts_info.area_name} = '" + cmblocaltion.Text + "'";
RPTHEAD = RPTHEAD + " for Area " + cmblocaltion.Text;
}
string crt = "";
if (crt1 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt1;
}
else
{
crt = crt1;
}
}
if (crt2 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt2;
}
else
{
crt = crt2;
}
}
if (crt3 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt3;
}
else
{
crt = crt3;
}
}
// if (crt3 != "") crt = crt + " aND " + crt3;
//if (crt4 != "") crt = crt + " aND " + crt4;
//crt = crt + " aND " + crt4 + " AND {DATA_ENTRY.TRN_TYPE} = 7";
if (crt4 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt4;
}
else
{
crt = crt4;
}
}
if (crt5 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt5;
}
else
{
crt = crt5;
}
}
if (crt6 != "")
{
if (crt != "")
{
crt = crt + " aND " + crt6;
}
else
{
crt = crt6;
}
}
//if (crt1 != "") crt2 = crt1 + " And " + crt2;
rep_formula = crt; // 2 + " aND " + crt3 + " aND " + crt4;// +" AND {QRY_ITEM.QTY}<>0";
//rep_formula = crt1 + " aND " + crt2 + " aND " + crt3 + " and " + crt4; //" AND {QRY_ITEM.QTY}<>0";
CrRep.SummaryInfo.ReportTitle = RPTHEAD; // "Account Detail Report from " + rdt1 + " To " + rdt2;
if (cmbtransaction.SelectedIndex == 1)
{
if (crt == "")
{
rep_formula = "{TRN_accounts.DR_CR}='D'";
}
else
{
rep_formula = crt + " AND {TRN_accounts.DR_CR}='D'";
}
CrRep.SummaryInfo.ReportTitle = RPTHEAD + ", For Trans of " + cmbtransaction.Text;
}
if (cmbtransaction.SelectedIndex == 2)
{
if (crt == "")
{
rep_formula = "{TRN_accounts.DR_CR}='C'";
}
else
{
rep_formula = crt + " AND {TRN_accounts.DR_CR}='C'";
}
CrRep.SummaryInfo.ReportTitle = RPTHEAD + ", For Trans of " + cmbtransaction.Text;
}
if (!cmbdept.Visible)
{
CrRep.ReportDefinition.Sections[5].SectionFormat.EnableSuppress = true;
CrRep.ReportDefinition.Sections[6].SectionFormat.EnableSuppress = true;
CrRep.ReportDefinition.Sections[9].SectionFormat.EnableSuppress = true;
CrRep.ReportDefinition.Sections[10].SectionFormat.EnableSuppress = true;
}
if (!panel2.Visible)
{
}
if (chkinvoice.Checked)
// CrRep.GetComponentName("invoice")
{
string sec = CrRep.ReportDefinition.Sections[8].Name;
CrRep.ReportDefinition.Sections[8].SectionFormat.EnableSuppress = false;
}
}
break;
}
//if (CRT4 != "")
// rep_formula = rep_formula + " AND " + CRT4;
CrRep.Load(rep_path);
//MessageBox.Show(rep_formula);
CrRep.ReportOptions.EnableSaveDataWithReport = false;
CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
Tables CrTables;
crconnectioninfo.ServerName = decoder.DataSource;
crconnectioninfo.DatabaseName = decoder.InitialCatalog;
crconnectioninfo.UserID = decoder.UserID;
crconnectioninfo.Password = decoder.Password;
//crconnectioninfo.ServerName = "Mujeeb-pc";
//crconnectioninfo.DatabaseName = "sqlStockex";
//crconnectioninfo.UserID = "sa";
//crconnectioninfo.Password = "******";
CrTables = CrRep.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtablelogoninfo = CrTable.LogOnInfo;
crtablelogoninfo.ConnectionInfo = crconnectioninfo;
CrTable.ApplyLogOnInfo(crtablelogoninfo);
}
CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, decoder.DataSource, decoder.InitialCatalog);
if (rep_formula != "")
{
CrRep.RecordSelectionFormula = rep_formula;
}
CrRep.SummaryInfo.ReportTitle = RPTHEAD;
// crystalReportViewer.ReportSource = reportDocument;
//ConnectionInfo connInfo = new ConnectionInfo();
//connInfo.ServerName = "dbservername";
//connInfo.DatabaseName = "dbname";
//connInfo.UserID = "dbusername";
//connInfo.Password = "******";
//reportViewer.ReportSource = GetReportSource(connInfo);
//reportViewer.RefreshReport();
// CrRep.Database.SetDataSource (db)
// CrRep.VerifyOnEveryPrint = False
//CrRep.DiscardSavedData
//CrRep.ReadRecords
//CrRep.Load(rep_path);
//Crv1.ReportSource = CrRep;
//Crv1.Width = this.Width;
FrmrepView frm = new FrmrepView();
frm.MdiParent = this.ParentForm;
frm.crv1.ReportSource = CrRep;
frm.Show();
//Control[] ctrls = frm.Controls.Find("crv1", false);
//if (ctrls.Length > 0)
//{
// CrystalDecisions.Windows.Forms.CrystalReportViewer rep = (CrystalDecisions.Windows.Forms.CrystalReportViewer) ctrls[0];
// rep.ReportSource = CrRep;
// frm.Show();
//}
CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, "Mujeeb", decoder.InitialCatalog);
//FRMREPORT.CRV1.ReportSource = CrRep
//FRMREPORT.CRV1.Refresh
//FRMREPORT.CRV1.RefreshEx (True)
//FRMREPORT.CRV1.ViewReport
//FRMREPORT.Show
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void print_reciept()
{
string crt;
string rep_path;
fnd = false;
try
{
ReportDocument CrRep = new ReportDocument();
rep_path = Application.StartupPath + "\\reports\\Rptsalary.rpt";
CrRep.Load(rep_path);
//CrRep.PrintOptions.PaperSize= CrystalDecisions.Shared.PaperSize.PaperEnvelope10;
crt = "{SALARY_DET.SALARY_MONTH} = '" + 0 + "'";
if (crt != "")
{
CrRep.RecordSelectionFormula = crt;
}
//CrRep.VerifyDatabase = false;
CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
Tables CrTables;
crconnectioninfo.ServerName = decoder.DataSource;
//crconnectioninfo.ServerName = "SqlZoomERP";
crconnectioninfo.DatabaseName = decoder.InitialCatalog;
crconnectioninfo.UserID = decoder.UserID;
crconnectioninfo.Password = decoder.Password;
CrTables = CrRep.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtablelogoninfo = CrTable.LogOnInfo;
crtablelogoninfo.ConnectionInfo = crconnectioninfo;
CrTable.ApplyLogOnInfo(crtablelogoninfo);
}
CrRep.SummaryInfo.ReportTitle = "Salary Report for Month ";
//CrRep.DataDefinition.FormulaFields["shipaddress"].Text = "'" + cmbaddress.Text + "'";
// CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, decoder.DataSource, decoder.InitialCatalog);
CrRep.ReadRecords();
//CrRep.Load();
// CrRep.ReadRecords();
CrRep.Refresh();
//if (chkprinter.Checked)
//{
// CrRep.PrintToPrinter(1, true, 0, 0);
//}
//else
//{
if (chkprintview.Checked)
{
FrmrepView frm = new FrmrepView();
frm.MdiParent = this.ParentForm;
frm.crv1.ReportSource = CrRep;
frm.Show();
return;
}
CrRep.PrintToPrinter(1, true, 0, 0);
return;
//}
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
}
}
private void repositoryItemLookUpEditCRRep_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.OK)
return;
RepCRGeneralFrm RepForm = new RepCRGeneralFrm();
if (mbReports.EditValue == null)
return;
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtableLogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.Database.Tables;
System.Data.SqlClient.SqlConnectionStringBuilder ConString = new System.Data.SqlClient.SqlConnectionStringBuilder(MyCL.SqlConStr);
crConnectionInfo.ServerName = ConString.DataSource;
crConnectionInfo.DatabaseName = "AATSdata";
crConnectionInfo.UserID = ConString.UserID;
crConnectionInfo.Password = ConString.Password;
MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].SetConnection(ConString.DataSource, "AATSdata", ConString.UserID, ConString.Password);
MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.SetDatabaseLogon(ConString.UserID, ConString.Password, ConString.DataSource, "AATSdata", true);
foreach (CrystalDecisions.Shared.IConnectionInfo info in MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections)
{
info.SetConnection(ConString.DataSource, "AATSdata", ConString.UserID, ConString.Password);
}
foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument sub in MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.Subreports)
{
foreach (CrystalDecisions.Shared.IConnectionInfo info in sub.DataSourceConnections)
{
info.SetConnection(ConString.DataSource, "AATSdata", ConString.UserID, ConString.Password);
}
}
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
RepForm.CRViewer.ReportSource = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport;
RepForm.CRViewer.Refresh();
RepForm.ReportName = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].RepCaption;
RepForm.MdiParent = this;
RepForm.Show();
return;
//Assign ConnectionString to Report
//System.Data.SqlClient.SqlConnectionStringBuilder ConString = new System.Data.SqlClient.SqlConnectionStringBuilder(MyCL.SqlConStr);
MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].SetConnection(ConString.DataSource, ConString.InitialCatalog, ConString.UserID, ConString.Password);
MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.SetDatabaseLogon(ConString.UserID, ConString.Password, ConString.DataSource, ConString.InitialCatalog, true);
MessageBox.Show(MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].ServerName);
MessageBox.Show(MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].DatabaseName);
MessageBox.Show(MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].UserID);
MessageBox.Show(MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport.DataSourceConnections[0].Password.ToString());
//Assign Report to Viewer
RepForm.CRViewer.ReportSource = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport;
RepForm.ReportName = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].RepCaption;
RepForm.MdiParent = this;
RepForm.Show();
}
private Boolean GenerateSchedReport()
{
Boolean res = false;
res = _ValidateReportFields();
if (!res)
{
return(false);
}
try
{
frmPrintReport frm = new frmPrintReport();
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions crParameterFieldDefinitions;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition crParameterFieldDefinition;
CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
objReport.Load(ClsConfig.PrintMonthlySchedule);
//tbPartCode.Text, Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString())
// , Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString())
crParameterDiscreteValue.Value = cboDeliverySchedMonth.SelectedValue.ToString();
crParameterFieldDefinitions = objReport.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@month"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = cboDeliverySchedYear.SelectedItem.ToString();
crParameterFieldDefinitions = objReport.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@year"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = cboCustomer.SelectedValue.ToString();
crParameterFieldDefinitions = objReport.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Cus_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
string sUserID = ClsConfig.User;
string sPassword = ClsConfig.Password;
string sServerName = ClsConfig.Server;
string sDatabaseName = ClsConfig.Database;
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
//crConnectionInfo.IntegratedSecurity = true;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
frm.crystalReportViewer1.ReportSource = objReport;
frm.crystalReportViewer1.Zoom(100);
frm.crystalReportViewer1.Refresh();
}
catch
{
MessageBox.Show("Report File Does Not Exists!");
}
return(true);
}
private void BtnPrint_Click(object sender, EventArgs e)
{
if (LUEcontractid.ItemIndex < 0)
return;
//RepCRGeneralFrm RepForm = new RepCRGeneralFrm();
CReports.CRContract CRRep = new CReports.CRContract();
CRRep.SetParameterValue(0, LUEcontractid.EditValue);
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtableLogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables = CRRep.Database.Tables;
//System.Data.SqlClient.SqlConnectionStringBuilder ConString = new System.Data.SqlClient.SqlConnectionStringBuilder(MyCL.SqlConStr);
System.Data.OleDb.OleDbConnectionStringBuilder AccConString = new OleDbConnectionStringBuilder(MyCL.AccConStr);
crConnectionInfo.ServerName = AccConString.DataSource;
crConnectionInfo.DatabaseName = "";
crConnectionInfo.UserID = "";
crConnectionInfo.Password = "";
CRRep.DataSourceConnections[0].SetConnection("", AccConString.FileName, false);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
//CRRep.PrintToPrinter(new System.Drawing.Printing.PrinterSettings(), new System.Drawing.Printing.PageSettings(), true);
CRRep.PrintToPrinter(1, true, 1, 2);
//RepForm.CRViewer.ReportSource = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].CRReport;
//RepForm.CRViewer.Refresh();
//RepForm.ReportName = MyCL.crRep[Convert.ToInt16(mbReports.EditValue)].RepCaption;
//RepForm.MdiParent = this;
//RepForm.Show();
}
public byte[] GenerateCrystalReport()
{
string reportPath = System.IO.Path.Combine(System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath, "CReports\\Reports");
string reportImagePath = System.IO.Path.Combine(System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath, "CReports\\Images");
//string _ReportImagePath = "";
//string _ReportPath = "";
string path = reportPath;
//_ReportImagePath = reportImagePath;
if (String.IsNullOrEmpty(path))
{
throw new MissingFieldException("CrystalReportPathNotSet");
}
if (reportName.IndexOf(":") < 0)
{
reportPath = path + "\\" + reportName;
}
else
{
reportPath = reportName;
}
ReportDocument rptBurndown = new ReportDocument();
if (File.Exists(reportPath)) //Check if the crystal report file exists in a specified location.
{
try
{
rptBurndown.Load(reportPath);
//Set Connection Info
ConnectionInfo.Get().SetAttributes(System.Configuration.ConfigurationManager.AppSettings["oracleConnectionString"]);
//Application will pick database info from the property file.
CrystalDecisions.Shared.ConnectionInfo crDbConnection = new CrystalDecisions.Shared.ConnectionInfo();
crDbConnection.IntegratedSecurity = false;
crDbConnection.DatabaseName = ConnectionInfo.Get().Db_name;
crDbConnection.UserID = ConnectionInfo.Get().Db_uid;
crDbConnection.Password = ConnectionInfo.Get().Db_pwd;
//crDbConnection.Type = ConnectionInfoType.Unknown;
crDbConnection.ServerName = ConnectionInfo.Get().Db_host;
CrystalDecisions.CrystalReports.Engine.Database crDatabase = rptBurndown.Database;
CrystalDecisions.Shared.TableLogOnInfo oCrTableLoginInfo;
foreach (CrystalDecisions.CrystalReports.Engine.Table oCrTable in crDatabase.Tables)
{
crDbConnection.IntegratedSecurity = false;
crDbConnection.DatabaseName = ConnectionInfo.Get().Db_name;
crDbConnection.UserID = ConnectionInfo.Get().Db_uid;
crDbConnection.Password = ConnectionInfo.Get().Db_pwd;
//crDbConnection.Type = ConnectionInfoType.Unknown;
crDbConnection.ServerName = ConnectionInfo.Get().Db_host;
oCrTableLoginInfo = oCrTable.LogOnInfo;
oCrTableLoginInfo.ConnectionInfo = crDbConnection;
oCrTable.ApplyLogOnInfo(oCrTableLoginInfo);
}
//Create Parameter query
string sql = SqlQuery;
StringBuilder sb = new StringBuilder(" WHERE ");
if (_pi.GetRecord_ID() > 0 && _pi.GetTable_ID() > 0)
{
string tableName = DB.ExecuteScalar("SELECT TableName FROM AD_Table WHERE AD_TABLE_ID =" + _pi.GetTable_ID()).ToString();
sb.Append(tableName).Append("_ID = ").Append(_pi.GetRecord_ID());
}
else
{
ProcessInfoUtil.SetParameterFromDB(_pi);
ProcessInfoParameter[] parameters = _pi.GetParameter();
if (parameters.Count() > 0)
{
int loopCount = 0;
for (int para = 0; para <= parameters.Count() - 1; para++)
{
string sInfo = parameters[para].GetInfo();
string sInfoTo = parameters[para].GetInfo_To();
if ((String.IsNullOrEmpty(sInfo) && String.IsNullOrEmpty(sInfoTo)) || sInfo == "NULL")
{
continue;
}
if (loopCount > 0)
{
sb.Append(" AND ");
}
string paramName = parameters[para].GetParameterName();
object paramValue = parameters[para].GetParameter();
object paramValueTo = parameters[para].GetParameter_To();
if (paramValue is DateTime)
{
sb.Append(paramName).Append(" BETWEEN ").Append(GlobalVariable.TO_DATE((DateTime)paramValue, true));
if (paramValueTo != null && paramValueTo.ToString() != String.Empty)
{
sb.Append(" AND ").Append(GlobalVariable.TO_DATE(((DateTime)paramValueTo).AddDays(1), true));
}
else
{
sb.Append(" AND ").Append(GlobalVariable.TO_DATE(((DateTime)paramValue).AddDays(1), true));
}
}
else if (paramValue != null && paramValue.ToString().Contains(','))
{
sb.Append(paramName).Append(" IN (")
.Append(paramValue.ToString()).Append(")");
}
else
{
sb.Append("Upper(").Append(paramName).Append(")").Append(" = Upper(")
.Append(GlobalVariable.TO_STRING(paramValue.ToString()) + ")");
}
loopCount++;
}
}
}
if (sb.Length > 7)
{
sql = sql + sb.ToString();
}
//if (form.IsIncludeProcedure())
//{
// bool result = StartDBProcess(form.GetProcedureName(), parameters);
//}
DataSet ds = DB.ExecuteDataset(sql);
if (ds == null)
{
ValueNamePair error = VLogger.RetrieveError();
throw new Exception(error.GetValue() + "BlankReportWillOpen");
}
bool imageError = false;
if (isIncludeImage)
{
for (int i_img = 0; i_img <= ds.Tables[0].Rows.Count - 1; i_img++)
{
String ImagePath = "";
String ImageField = "";
if (ds.Tables[0].Rows[i_img][imagePathField] != null)
{
ImagePath = ds.Tables[0].Rows[i_img][imagePathField].ToString();
ImageField = imageField;
if (ds.Tables[0].Columns.Contains(ImageField))
{
if (File.Exists(reportImagePath + "\\" + ImagePath))
{
byte[] b = StreamFile(reportImagePath + "\\" + ImagePath);
ds.Tables[0].Rows[i_img][ImageField] = b;
}
else
{
//ds.Tables[0].Rows.RemoveAt(i_img);
imageError = true;
}
}
else
{
imageError = true;
}
}
else
{
imageError = true;
}
}
}
if (imageError)
{
// ShowMessage.Error("ErrorLoadingSomeImages", true);
}
//crystalReportViewer1.ReportSource = rptBurndown;
//crystalReportViewer1.Refresh();
System.IO.Stream oStream;
byte[] byteArray = null;
rptBurndown.SetDataSource(ds.Tables[0]); //By karan approveed by lokesh......
//rptBurndown.PrintOptions.ApplyPageMargins(new CrystalDecisions.Shared.PageMargins(100, 360, 100, 360));
oStream = rptBurndown.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length));
return(byteArray);
//if (form.IsDirectPrint())
//{
// // rptBurndown.PrintOptions.PrinterName = Env.GetCtx().GetPrinterName();
// //rptBurndown.PrintToPrinter(1, false, 0, 0);
//}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
throw new MissingFieldException("CouldNotFindTheCrystalReport");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//this takes request parameters only from the query string
string SalesOrderID = Request.QueryString["salesorderid"];
if (SalesOrderID == null)
{
//SalesOrderID = "QDEMOA0019C7"; //FOR Testing
}
if (SalesOrderID == null)
{
Response.Write("No Valid SalesOrderID provided");
}
else
{
try
{
Sage.Entity.Interfaces.ISalesOrder salesOrder = Sage.Platform.EntityFactory.GetById<Sage.Entity.Interfaces.ISalesOrder>(SalesOrderID);
string reportPath = Server.MapPath("CrystalReports\\PickingListDetail.rpt");
CrystalDecisions.CrystalReports.Engine.ReportDocument crReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crReport.Load(reportPath);
crReport.RecordSelectionFormula = "{SALESORDER.SALESORDERID} = '" + salesOrder.Id.ToString() + "'";
//Retrieve connection string information
// get the DataService to get a connection string to the database
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>();
string connectionString = datasvc.GetConnectionString();
System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();
builder.ConnectionString = connectionString;
string password = builder["Password"].ToString();
string username = builder["User ID"].ToString();
string dataSource = datasvc.Server;
string initialCatalog = datasvc.Alias;
//Define new connection for Crystal Report
CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
connectionInfo.DatabaseName = initialCatalog;
connectionInfo.UserID = username;
connectionInfo.Password = password;
connectionInfo.ServerName = dataSource;
// set report connection for main report
SetDBLogonForReport(connectionInfo, crReport);
// set report connection for any subreports
SetDBLogonForSubreports(connectionInfo, crReport);
//System.IO.MemoryStream ms = (System.IO.MemoryStream)crReport.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
//Response.BinaryWrite(ms.ToArray());
String filename = "exportedPDF/PickingList" + salesOrder.AlternateKeyPrefix + "-" + salesOrder.AlternateKeySuffix + ".pdf";
crReport.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath(filename));
//string popupScript = "<script language='javascript'>" + "window.open('C:/BiWeeklyReport.pdf'); <//script>";
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popupOpener", "var popup=window.open('" + filename + "');popup.focus();", true);
//string jsScript = "window.close();";
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlertJS", jsScript, true);
//Page.ClientScript.RegisterOnSubmitStatement(typeof(Page), "closePage", "window.onunload = CloseWindow();");
Response.Redirect(filename);
}
catch (System.Threading.ThreadAbortException ex)
{
}
finally
{
//Response.End();
}
}
}
public void GenerateReport()
{
try
{
string filepart = @"file:\";
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions crParameterFieldDefinitions;
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition crParameterFieldDefinition;
CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
if (File.Exists(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().CodeBase).Replace(filepart, "") + @"\PEZA_REPORTS\rpt_PEZA_8106_BoatNote.rpt"))
{
objReport1.Load(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().CodeBase).Replace(filepart, "") + @"\PEZA_REPORTS\rpt_PEZA_8106_BoatNote.rpt");
}
else
{
objReport1.Load(ClsConfig.PEZAReportPath_Trial + "rpt_PEZA_8106_BoatNote.rpt");
}
crParameterDiscreteValue.Value = _formNo.ToString().Trim();//recDate.SelectedDate.Value;
crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@8106FormNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//objReport1.SetParameterValue("@8106FormNo", "14176560");
string sUserID = ClsConfig.ReportUser;
string sPassword = ClsConfig.ReportPassword;
string sServerName = ClsConfig.ReportServer;
string sDatabaseName = ClsConfig.ReportDatabase_PEZA;
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
//crConnectionInfo.IntegratedSecurity = true;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport1.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
reportViewer.ViewerCore.ReportSource = objReport1;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void print_reciept()
{
string crt;
string rep_path;
fnd = false;
try
{
if (string.IsNullOrEmpty(Txtitem.Text))
{
return;
}
ReportDocument CrRep = new ReportDocument();
//crconnectioninfo.ServerName = "Mujeeb";
//crconnectioninfo.DatabaseName = "Printex";
//crconnectioninfo.UserID = "sa";
//crconnectioninfo.Password = "******";
crt = "{Reciepts.Reciept_no} =" + Convert.ToDouble(Txtitem.Text);
rep_path = Application.StartupPath + "\\reports\\Receipt.rpt";
CrRep.Load(rep_path);
//CrRep.PrintOptions.PaperSize= CrystalDecisions.Shared.PaperSize.PaperEnvelope10;
CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
Tables CrTables;
crconnectioninfo.ServerName = decoder.DataSource;
crconnectioninfo.DatabaseName = decoder.InitialCatalog;
crconnectioninfo.UserID = decoder.UserID;
crconnectioninfo.Password = decoder.Password;
CrTables = CrRep.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtablelogoninfo = CrTable.LogOnInfo;
crtablelogoninfo.ConnectionInfo = crconnectioninfo;
CrTable.ApplyLogOnInfo(crtablelogoninfo);
}
//ConnectionInfo connInfo = new ConnectionInfo();
//connInfo.ServerName = "dbservername";
//connInfo.DatabaseName = "dbname";
//connInfo.UserID = "dbusername";
//connInfo.Password = "******";
//reportViewer.ReportSource = GetReportSource(connInfo);
CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, "Mujeeb", decoder.InitialCatalog);
//CrRep.Load();
// CrRep.ReadRecords();
//CrRep.Refresh();
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
}
}
