带有VS2010错误的Report Builder 3.0

| 我使用Report Builder 3.0构建了一个报表，并试图在VS 2010中使用报表查看器显示该报表。我一直收到此错误消息。报告定义无效。详细信息：报表定义具有无效的目标命名空间\'http：//schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition \'，该命名空间无法升级。这是我正在使用的代码。

public partial class ViewReport : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
            PopulateReport(GetDataSet(\"24\"), Server.MapPath(\"/IncidentReportOld.rdl\"));
    }
    private DataSet GetDataSet(string id)
    {
        string sql = string.Empty;
        SqlDataAdapter ada;
        string conString = \"Data Source=con-sqlc-02;Initial Catalog=Incident;Integrated Security=True\";

        DataSet ds = new DataSet();

        sql = \"select * from Rpt_Incident where incidentID = \" + id;
        ada = new SqlDataAdapter(sql, conString);
        ada.Fill(ds, \"Incidents\");

        return ds;
    }

    private void PopulateReport(DataSet ds, string reportPath)
    {
        /* Put the stored procedure result into a dataset */

        if (ds.Tables[0].Rows.Count == 0)
        {
            //lblMessage.Text = \"Sorry, no record returned in this report\";
        }
        else
        {

            // Set ReportViewer1
            ReportViewer rv = new ReportViewer();
            rv.LocalReport.ReportPath = reportPath;
            ReportDataSource datasource;
            rv.LocalReport.DataSources.Clear();
            for (int i = 0; i < ds.Tables.Count; i++)
            {
                datasource = new ReportDataSource(ds.Tables[i].TableName, ds.Tables[i]);
                rv.LocalReport.DataSources.Add(datasource);
            }

            RenderPDF(rv);
        }
    }

    private void RenderPDF(ReportViewer rv)
    {
        Warning[] warnings;
        string[] streamids;
        string mimeType;
        string encoding;
        string extension;

        byte[] bytes = rv.LocalReport.Render(\"PDF\", null, out mimeType, out encoding, out extension, out streamids, out warnings);

        this.Page.Response.ClearHeaders();
        this.Page.Response.AddHeader(\"content-disposition\", \"inline; filename=IncidentTest.pdf\");
        this.Page.Response.ClearContent();
        this.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
        this.Page.Response.ContentType = \"application/pdf\";

        BinaryWriter writer = new BinaryWriter(this.Page.Response.OutputStream);
        writer.Write(bytes);

        writer.Close();

        //flush and close the response object
        this.Page.Response.Flush();
        this.Page.Response.Close();
    }
    private void PopulateReport1(DataSet ds, string reportPath)
    {
        /* Put the stored procedure result into a dataset */

        if (ds.Tables[0].Rows.Count == 0)
        {
            //lblMessage.Text = \"Sorry, no record returned in this report\";
        }
        else
        {

            // Set ReportViewer1
            //ReportViewer rv = new ReportViewer();
            ReportViewer1.LocalReport.ReportPath = reportPath;
            ReportDataSource datasource;
            ReportViewer1.LocalReport.DataSources.Clear();
            for (int i = 0; i < ds.Tables.Count; i++)
            {
                datasource = new ReportDataSource(ds.Tables[i].TableName, ds.Tables[i]);
                ReportViewer1.LocalReport.DataSources.Add(datasource);
            }

            ReportViewer1.LocalReport.Refresh();
            //RenderPDF(rv);
        }
    }


}

已邀请:

3 个回复

香腔弥胯瓤

我实际上可以自己解决此问题。我只是将扩展名从RDL更改为RDLC。然后我在VS中打开它，VS问我是否要转换它。我说是，然后得到了此错误消息。报表定义具有无效的目标名称空间\'http：//schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition \'，该名称空间无法升级。因此，我将命名空间更改为SQL Reporting Services 2008的命名空间。

<Report xmlns:rd=\"http://schemas.microsoft.com/SQLServer/reporting/reportdesigner\" xmlns=\"http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition\">

之后，我收到一条错误消息，说\“ ReportSections \”是无效的子元素。我将其删除，然后一切正常！希望这可以帮助其他人解决此问题。