Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

As you might recall, I mentioned earlier that when changes are made to a report part and it is saved
out to the report server, each of the reports that use that report part are then notified of the example. Use
the following steps to see this in action:



  1. Once you have Report Builder started, click on the Report Builder icon in the
    top left corner and click Open.

  2. Navigate to the location that you have extracted the Pro_SSRS solution and
    locate the EmployeeSvcCost_RB3_ReportPart.rdl file. Click Open to load the
    report in Report Builder 3.0. This report is the same report that we opened up
    earlier. We are now going to make a minor change and then re-publish the
    report part.

  3. Change the font color of the chart title to be Blue and italicized. No major
    changes, we just want to see what happens when you change a report part.
    Deploy the report part using the Publish Report Parts as we did earlier from the
    Report Builder menu button. Only publish the chart this time.

  4. Now, let’s go and open the
    EstimatedCostByBranch_RB3_Report_Using_ReportPart that we saved to the
    report server which has a copy of the original report part. Click the Report
    Builder menu button and select Open. Navigate to the report server location
    where you saved the report and open the
    EstimatedCostByBranch_RB3_Report_Using_ReportPart report. When you
    open the report, you should see a message box titled “Updated Report Parts”
    pop up between the tabstrip and report design surface (Figure 13-75). This is
    our indicator stating that our report part that we consumed has been altered.

Free download pdf