public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RptSetorTipo rpt = new RptSetorTipo(); rpt.Site = this.Site; return(rpt); }
private void VisualizarRptSetor_Load(object sender, EventArgs e) { try { NpgsqlConnection conn = new NpgsqlConnection("Server=localhost; Port=5432; User Id=postgres; Password=@postgre; Database=ouvidoria;"); conn.Open(); NpgsqlCommand comando = new NpgsqlCommand("SELECT * FROM manifestacao WHERE (setor1 = @setor1 OR setor2 = @setor2 OR setor3 = @setor3 OR setor4 = @setor4) AND (data_gravacao BETWEEN @dataInicial AND @dataFinal)", conn); comando.Parameters.AddWithValue("@setor1", setor1); comando.Parameters.AddWithValue("@setor2", setor2); comando.Parameters.AddWithValue("@setor3", setor3); comando.Parameters.AddWithValue("@setor4", setor4); comando.Parameters.AddWithValue("@dataInicial", dataInicio); comando.Parameters.AddWithValue("@dataFinal", dataFim); NpgsqlDataAdapter da = new NpgsqlDataAdapter(comando); DataSet ds = new DataSet(); DataTable manifestacao = new DataTable(); da.Fill(manifestacao); RptSetorTipo rptSetorTipo = new RptSetorTipo(); rptSetorTipo.SetDataSource(manifestacao); crystalReportViewerRptSetor.ReportSource = rptSetorTipo; crystalReportViewerRptSetor.Refresh(); this.WindowState = FormWindowState.Maximized; } catch { MessageBox.Show("PostgreSQL Error!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }