示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            RelSldVdFinanc rpt = new RelSldVdFinanc();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!IsPostBack)
        //{
        Controle_Dados.Funcoes Controle = new Funcoes();
        if (Session["SQLRel"] == null)
        {
            Response.Redirect("TelaPrincipal.aspx");
        }
        else
        {
            string SQL = Session["SQLRel"].ToString();
            //Variáveis
            CrystalDecisions.CrystalReports.Engine.ReportDocument crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            //Cria a instância do Report
            if (Request.QueryString["Relatorio"].ToString() == "TabPreco")
            {
                crReportDocument = new ERP_SGE_PEDWEB.RelTabPreco();
            }
            if (Request.QueryString["Relatorio"].ToString() == "SldVdFin")
            {
                crReportDocument = new ERP_SGE_PEDWEB.RelSldVdFinanc();
            }

            SqlConnection Conn = new SqlConnection();
            //SqlDataAdapter daRelatorio = new SqlDataAdapter();
            DataSet dataSet = new DataSet();
            //Abre o Banco de Dados
            Conn.ConnectionString = "Data Source=SERVIDOR; Initial Catalog=BD_ERP_SGE; User ID=talimpo; Password=systalimpo; MultipleActiveResultSets=True;";
            Conn.Open();
            //Propriedades do Command
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = SQL;
            cmd.CommandType = CommandType.Text;
            cmd.Connection  = Conn;
            //Passa as propriedades do Command para o DataAdapter
            SqlDataAdapter daRelatorio = new SqlDataAdapter(cmd);
            //Carrega o DataSet com o nome de "ProductsReport"
            daRelatorio.Fill(dataSet);
            //Passa o DataSer para o relatório
            crReportDocument.SetDataSource(dataSet);
            crReportDocument.SetDataSource(dataSet.Tables[0]);
            //Parra para o Viewer o nosso relatório
            crvRelatorio.ReportSource = crReportDocument;
        }
        //}
    }