private void button1_Click(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ContratoEmpreteiro1; CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["Contrato"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(TxtBoxContrato.Text); report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void GerarButton_Click(object sender, EventArgs e) { if (!checkBox1.Checked) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicao1; CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["DataInicial"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(DataInicialDTP.Value.Date.ToShortDateString()); parm = report.ParameterFields["DataFinal"]; parm.CurrentValues.AddValue(DataFinalDTP.Value.Date.ToShortDateString()); report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); } else { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.ServicoMedicaoTOP1; report.SetDatabaseLogon("scoop", "scoop", @"pmc0091srvsipa1", "scoop"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); } }
private void button1_Click(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportClass report = this.RelatorioMedicao1; this.RelatorioMedicao1.RecordSelectionFormula = ""; if (DotacaoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula = DotacaoFiltro; if (TipoObraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + TipoObraFiltro; if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } else { if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } } else { if (TipoObraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += TipoObraFiltro; if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } } else { if (BairroFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += BairroFiltro; if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and " + EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } else { if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")";; } } } else { if (EmpreteiraFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += EmpreteiraFiltro; if (PeriodoFiltro != null) { this.RelatorioMedicao1.RecordSelectionFormula += " and {Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")"; } } else { if (!PeriodoChkBox.Checked) { this.RelatorioMedicao1.RecordSelectionFormula = "{Medicao.Dt_Criacao} in DateTime (" + DtInicialdateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ") to DateTime (" + DtFinaldateTimePicker.Value.Date.ToString("yyyy,MM,dd,HH,mm,ss") + ")"; } } } } } this.RelatorioMedicao1.Refresh(); CrystalDecisions.Shared.ParameterField parm; parm = report.ParameterFields["Filtro"]; parm.CurrentValues.Clear(); parm.CurrentValues.AddValue(DotacaoFiltro == ""?"":"Dotação Orçamentaria" + " " + TipoObraFiltro == ""?"":"Tipo Orçamento" + " " + BairroFiltro == ""?"":"Bairro" + " " + EmpreteiraFiltro == ""?"":"Empreteira" + " " + PeriodoFiltro == ""?"":"Periodo "); report.SetDatabaseLogon("scoop", "scoop", @"PMC0091SRVSIPA1", "scoop", true); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }