public void ShowReport(CrystalDecisions.Windows.Forms.CrystalReportViewer obj, string sql, string repname)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
try
{
objReport.Load(repname);
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objReport.Database.Tables)
{
ConInfo = tbCurrent.LogOnInfo;
ConInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["ReportProvider"];
ConInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
ConInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
ConInfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["Database Name"];
tbCurrent.ApplyLogOnInfo(ConInfo);
}
DataSet objds = Select(sql);
objReport.SetDataSource(objds.Tables[0]);
obj.ReportSource = objReport;
}
catch
{
//return null;
}
finally
{
}
}
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);
}
}
public void ReportConvert(CrystalDecisions.CrystalReports.Engine.ReportDocument argObjectReport, string[] argDatafiles)
{
try
{
int icnt = 0;
{
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
string ardata = Convert.ToString(argDatafiles[0]);
ConInfo.ConnectionInfo.UserID = BsfGlobal.g_sUserId;
ConInfo.ConnectionInfo.Password = BsfGlobal.g_sPassWord;
ConInfo.ConnectionInfo.ServerName = BsfGlobal.g_sServerName;
for (; icnt <= argObjectReport.Database.Tables.Count - 1; icnt++)
{
if (icnt < argDatafiles.Length)
{
ConInfo.ConnectionInfo.DatabaseName = argDatafiles[icnt];
}
argObjectReport.Database.Tables[icnt].ApplyLogOnInfo(ConInfo);
}
}
}
catch (Exception ex)
{
//Interaction.MsgBox("Error: " + Except.Message);
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void frmChiTietThuLai_Load(object sender, EventArgs e)
{
ChiTietThuLai rpt = new ChiTietThuLai();
CrystalDecisions.CrystalReports.Engine.Table tblCurrent;
CrystalDecisions.Shared.TableLogOnInfo tliCurrent = new CrystalDecisions.Shared.TableLogOnInfo();
DataService InfoSQL = new DataService();
try
{
for (int i = 0; i < rpt.Database.Tables.Count; i++)
{
tblCurrent = rpt.Database.Tables[i];
tliCurrent.ConnectionInfo.ServerName = InfoSQL.servername;
tliCurrent.ConnectionInfo.UserID = InfoSQL.username;
tliCurrent.ConnectionInfo.Password = InfoSQL.password;
tliCurrent.ConnectionInfo.DatabaseName = InfoSQL.database;
//if(InfoSQL.security.Equals("True"))
tliCurrent.ConnectionInfo.IntegratedSecurity = Convert.ToBoolean(InfoSQL.security);
tblCurrent.ApplyLogOnInfo(tliCurrent);
}
}
catch { }
crystalReportViewer1.ReportSource = rpt;
}
public void ReportConvert(CrystalDecisions.CrystalReports.Engine.ReportDocument argObjectReport, string[] argDatafiles)
{
try
{
int icnt = 0;
{
BsfGlobal.GetDBString();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
string ardata;
ardata = Convert.ToString(argDatafiles[0]);
ConInfo.ConnectionInfo.UserID = BsfGlobal.g_sUserId;
ConInfo.ConnectionInfo.Password = "******";
ConInfo.ConnectionInfo.ServerName = BsfGlobal.g_sServerName;
for (; icnt <= argObjectReport.Database.Tables.Count - 1; icnt++)
{
ConInfo.ConnectionInfo.DatabaseName = argDatafiles[icnt];
argObjectReport.Database.Tables[icnt].ApplyLogOnInfo(ConInfo);
}
}
}
catch
{
//Interaction.MsgBox("Error: " + Except.Message);
}
}
public void ViewReport(CrystalDecisions.Windows.Forms.CrystalReportViewer CrViewer, string Reportname, string rsSelectionformula, string paraname1, string paraname2, string paraname3, string paraname4, string paraname5, string paraname6, string paraname7, string paravalue1, string paravalue2, string paravalue3, string paravalue4, string paravalue5, string paravalue6, string paravalue7, int SendToPrinter, Form frm)
{
rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string REPORTSPATH = Application.StartupPath + ConfigurationManager.AppSettings["ShareFolder"];
rpt.Load((REPORTSPATH + ("\\" + Reportname)));
rpt.SetParameterValue(paraname1, paravalue1);
rpt.SetParameterValue(paraname2, paravalue2);
rpt.SetParameterValue(paraname3, paravalue3);
rpt.SetParameterValue(paraname4, paravalue4);
rpt.SetParameterValue(paraname5, paravalue5);
rpt.SetParameterValue(paraname6, paravalue6);
rpt.SetParameterValue(paraname7, paravalue7);
// CrystalDecisions.CrystalReports.Engine.Table tdCurr;
foreach (CrystalDecisions.CrystalReports.Engine.Table tdCurr in rpt.Database.Tables)
{
rptTLInfo = new CrystalDecisions.Shared.TableLogOnInfo();
rptTLInfo = tdCurr.LogOnInfo;
// With...
//SERVERNAME.Password = "******";
//dataBaseName.ServerName = "SA";
rptTLInfo.ConnectionInfo.DatabaseName = "IMS";
tdCurr.ApplyLogOnInfo(rptTLInfo);
}
rpt.SetDatabaseLogon("", "", ".", "IMS");
rpt.SummaryInfo.ReportAuthor = RptAuthor;
if ((rsSelectionformula != ""))
{
rpt.RecordSelectionFormula = rsSelectionformula;
}
if ((SendToPrinter == 1))
{
try
{
rpt.PrintToPrinter(1, true, 1, 1);
}
catch (Exception ex)
{
// MsgBox(ex.Message);
}
}
else
{
//if (((Para1 == null)
// == false)) {
// CrViewer.ParameterFieldInfo = parameters;
//}
CrViewer.ReportSource = rpt;
CrViewer.Refresh();
if ((frm.Tag != "ALL BILL REPORT"))
{
// frm.Show();
// SHOW_PLEASE_WAIT(false);
}
}
}
protected void Page_Init(object sender, System.EventArgs e)
{
try
{
string sPath = HttpContext.Current.Request.MapPath("~/Report\\");
//表示一个报表，并且包含定义、格式化、加载、导出和打印该报表的属性和方法。
CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.ParameterDiscreteValue discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ParameterValues paraValues = new CrystalDecisions.Shared.ParameterValues();
//加载你事先做好的Crystal Report报表文件
Report.Load(sPath + Request.QueryString["ReportName"], CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy);
string sData = PublicApi.fnGetConStr("MNDT").Replace(";", ",");
// 設定報表內SQL Server資料庫的登入資訊
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Report.Database.Tables)
{
logonInfo = table.LogOnInfo;
var _with1 = logonInfo.ConnectionInfo;
_with1.ServerName = fnGetData(sData, "Data Source");
_with1.DatabaseName = fnGetData(sData, "Initial Catalog");
_with1.UserID = fnGetData(sData, "User ID");
_with1.Password = fnGetData(sData, "Password");
table.ApplyLogOnInfo(logonInfo);
}
Report.SetDataSource(Session["PrintDT"]);
//Session["PrintDT"] = null;
if (Report.ParameterFields["列印人員"] != null)
{
Report.SetParameterValue("列印人員", Session["sId"]);
}
if (Report.ParameterFields["進貨稅額"] != null)
{
string sSql =
" SELECT [parameter] " +
" FROM [mndtkind_details] " +
" WHERE [kind_id] = 'TAX' " +
" AND [code_id] = 'IN' ";
Report.SetParameterValue("進貨稅額", PublicApi.fnGetValue(sSql, "MNDT"));
}
CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX; //列印顯示列印選項，但只有IE會出現這功能
//Report.PrintToPrinter(1, true, 0, 0); // 直接列印
CrystalReportViewer1.ReportSource = Report;
//CrystalReportViewer1.HasExportButton = false; //將匯出的功能False掉
//CrystalReportViewer1.HasPrintButton = false;
//CrystalReportViewer1.HasToggleGroupTreeButton = false; //將樹狀結構的按鈕False掉
//CrystalReportViewer1.DisplayGroupTree = false; //將樹狀結構狀態False掉
}
catch (Exception e1)
{
//Functions.fnMessageBox(e1.ToString(), this);
}
}
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");
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
CrystalReport_tkNhaPhanPhoi report = new CrystalReport_tkNhaPhanPhoi();
CrystalDecisions.Shared.TableLogOnInfo tlicurrent = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbcurrent in report.Database.Tables)
{
tlicurrent = tbcurrent.LogOnInfo;
tlicurrent.ConnectionInfo.ServerName = Environment.MachineName;
tbcurrent.ApplyLogOnInfo(tlicurrent);
}
}
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());
}
}
public static void SetTableLogin(CrystalDecisions.CrystalReports.Engine.Table table)
{
CrystalDecisions.Shared.TableLogOnInfo tliCurrent = table.LogOnInfo;
tliCurrent.ConnectionInfo.UserID = builder.UserID;
tliCurrent.ConnectionInfo.Password = builder.Password;
if (builder.InitialCatalog != null)
{
tliCurrent.ConnectionInfo.DatabaseName = builder.InitialCatalog;
}
if (builder.DataSource != null)
{
tliCurrent.ConnectionInfo.ServerName = builder.DataSource;
}
table.ApplyLogOnInfo(tliCurrent);
}
public void Connect()
{
CrystalDecisions.Shared.TableLogOnInfo tliCurrent = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in rpt.Database.Tables)
{
tliCurrent = tbCurrent.LogOnInfo;
tliCurrent.ConnectionInfo.ServerName = QUANLYHOSONHANVIEN.Properties.Settings.Default.servername;
tliCurrent.ConnectionInfo.UserID = QUANLYHOSONHANVIEN.Properties.Settings.Default.user;
tliCurrent.ConnectionInfo.Password = QUANLYHOSONHANVIEN.Properties.Settings.Default.pass;
tliCurrent.ConnectionInfo.DatabaseName = QUANLYHOSONHANVIEN.Properties.Settings.Default.databaseName;
tbCurrent.ApplyLogOnInfo(tliCurrent);
}
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
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");
}
private void BindReport(string reportName)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath(Constz.HomeFolder + "Reports/" + reportName + ".rpt");
rpt.Load(reportPath);
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
logonInfo = rpt.Database.Tables[0].LogOnInfo;
logonInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["DB_SERVER"].ToString().Trim();
logonInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["DB_USER"].ToString().Trim();
logonInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["DB_PASSWORD"].ToString();
rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo);
CrystalDecisions.Shared.ParameterValues curValue = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue paraValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
for (int i = 0; i < Request.QueryString.Count; ++i)
{
string field = Request["paramfield" + (i + 1).ToString()];
string value = Request["paramvalue" + (i + 1).ToString()];
if (field != null && value != null)
{
paraValue.Value = value;
curValue = rpt.ParameterFields[field].CurrentValues;
curValue.Add(paraValue);
rpt.ParameterFields[field].CurrentValues = curValue;
}
else
break;
}
//paraValue.Value = reportKey;
//curValue = rpt.ParameterFields["LOID"].CurrentValues;
//curValue.Add(paraValue);
//rpt.ParameterFields["LOID"].CurrentValues = curValue;
rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
if (Request["landscape"] != null)
{
if (Request["landscape"] == "1") rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
}
Page.Cache["rpt"] = rpt;
ctlReportViewer.ReportSource = Page.Cache["rpt"];
//ctlReportViewer.DataBind();
}
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 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);
}
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_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 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();
}
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);
}
}
public MATRIX_RPT(string rptname)
{
TB_rpt.Rows.Clear();
Column = new DataColumn();
Column.DataType = typeof(String);
Column.ColumnName = "المسار";
//Column.Caption = "المسار";
TB_rpt.Columns.Add(Column);
string path = "";
GetRptPath(Application.StartupPath + @"\Reports\", rptname);
CrystalDecisions.Shared.TableLogOnInfo LI = new CrystalDecisions.Shared.TableLogOnInfo();
try
{
DEC.Load(path);
}
catch (Exception)
{
throw new Exception(" التقرير قيد التطوير ");
}
foreach (Table T in DEC.Database.Tables)
{
//LI = T.LogOnInfo;
//LI.ConnectionInfo.ServerName = Properties.Settings.Default.ServerName;
//LI.ConnectionInfo.DatabaseName = Properties.Settings.Default.DataBase;
//if (Pub.Authentication == "0")
//{
// LI.ConnectionInfo.IntegratedSecurity = true;
//}
//else
//{
// LI.ConnectionInfo.UserID = Properties.Settings.Default.UserName;
// LI.ConnectionInfo.Password = Properties.Settings.Default.UserPassword;
//}
//T.ApplyLogOnInfo(LI);
}
for (int SubR = 0; SubR < DEC.Subreports.Count; SubR++)
{
foreach (Table TableInfo in DEC.Subreports[SubR].Database.Tables)
{
//LI = TableInfo.LogOnInfo;
//LI.ConnectionInfo.ServerName = Properties.Settings.Default.ServerName;
//LI.ConnectionInfo.DatabaseName = Properties.Settings.Default.DataBase;
//if (Pub.Authentication == "0")
//{
// LI.ConnectionInfo.IntegratedSecurity = true;
//}
//else
//{
// LI.ConnectionInfo.UserID = Properties.Settings.Default.UserName;
// LI.ConnectionInfo.Password = Properties.Settings.Default.UserPassword;
//}
//TableInfo.ApplyLogOnInfo(LI);
}
}
}
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);
}
}
