SQL Server Performance

RDL changes

Discussion in 'SQL Server 2008 Reporting Services' started by ramasubbup, Jun 10, 2009.

  1. ramasubbup New Member

    Please let me know if we need to do any RDL file changes for reports, if my underlying data source chages from SQL Server 2005 to 2008
  2. satya Moderator

    Obviously, be sure to choose a data source schema that is the same as or structurally identical to the one used in the original report. If the schema is different, the report layout might not be valid for the data source you want to use. If you want to use different data sources, it is easier to re-create the report from the beginning rather than convert it.
    RDL-to-RDLC Conversion
    When converting a .rdl file to .rdlc format, you must manually replace the data source and query information in the report definition with data constructs provided in your application.
    1. Rename the .rdl file to use the .rdlc file extension.
      • In Visual Studio 2008, open the solution or project that will contain the report.
        • Create or add the dataset that defines the data you want to use to your projector solution. For more information, see Creating Data Sources for a Report.
          • On the Project menu, click Add Existing Item and then select the .rdlc file that you created in the first step.
            • In the project, open the form or Web page that will contain the report.
              • From the Toolbox, in the Data group, drag a ReportViewer control onto the form or Web page.
                • In the ReportViewer Tasks smart tags panel, in Choose Reports, select the .rdlc file to use with the control.
                  • In the ReportViewer Tasks smart tags panel, in Choose Data Sources, select the dataset you want to use. The dataset object, binding source object, and table object will appear at the bottom of the workspace. For more information about updating data source references, see Updating and Rebinding Data Source References (Visual Studio Report Designer).
                    • Save all files, and then build or deploy the project to verify that the report contains the data you expect.

Share This Page