Pro SQL Server 2012 Reporting Services

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


  1. If permissions are set appropriately (Content Manager) on the reporting
    server, you should see two green checkmarks next to the report parts that we
    had selected to deploy. Click Close to return to Report Builder.

  2. Now that we have our report parts deployed, now it is time to create a report
    that consumes the report part. Click on the Report Builder menu button again
    and choose New and then choose to create a Blank report. After the new report
    is loaded change the title of the report to “Estimated Cost by Branch”.

  3. Click on the Insert tab in the tabstrip and then select Report Parts. You should
    see the Report Part Gallery window pane become visible on the right side of
    the screen, as shown in Figure 13-73. From the Report Part Gallery window,
    you can search for report parts and see things like what report parts are out
    there as well as who created them. You can even see what the report part looks
    like when previewing in thumbnail view.


Figure 13-73. Viewing the report part gallery



  1. To use a report part in a report, it is as easy as dragging and dropping the
    report part onto our design surface. With that being said, drag the
    EstimatedCostByBranch_Pie chart over onto the design surface and set the left
    side to be aligned with the header. Click on the home tab and then run the
    report. Executing the report with ServiceYear 2009 can be seen in Figure 13-74.

  2. Save the report to the report server as we did in earlier examples with the name
    of EstimatedCostByBranch_RB3_Report_Using_ReportPart. We will be looking
    at this report this later after modifying the report part.

Free download pdf