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