水晶报表

 

    /// <summary>
    /// 报表实例 - 数据集 DataShuJu.xsd
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        TableLogOnInfo logOnInfo = new TableLogOnInfo();

        ReportDocument oRpt = new ReportDocument();
        //获取数据
        //DataShuJu的映射DataSet
        DataSet ds = blltbMemberReport.GetAllList();
        //填充报表
        oRpt.Load(Server.MapPath("CrystalReport.rpt"));
        //注意此处必需指明Dataset中的表的名称，否则会提示“您请求的报表需要更多信息。”
        oRpt.SetDataSource(ds.Tables["ds"]);

        //设置登陆信息
        //设置logOnInfo参数，从web.config中获取logOnInfo参数信息
        logOnInfo.ConnectionInfo.ServerName = System.Configuration.ConfigurationSettings.AppSettings["Servername"];
        logOnInfo.ConnectionInfo.DatabaseName = System.Configuration.ConfigurationSettings.AppSettings["Database"];
        logOnInfo.ConnectionInfo.UserID = System.Configuration.ConfigurationSettings.AppSettings["Userid"];
        logOnInfo.ConnectionInfo.Password = System.Configuration.ConfigurationSettings.AppSettings["Password"];

        //为所要访问的库中的表加上登陆信息
        oRpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo);

        CrystalReportViewer1.ReportSource = oRpt;
        CrystalReportViewer1.DataBind();
    }