Report Builder 2.0 - Modifying a Basic Report

Hands-on exercise 6.2: Modifying a basic report

In this exercise, the report created in Chapter 4 will be modified to illustrate the formatting, layout, and other capabilities built into the Report Builder. A number of other features of Report Builder will be taken up in the next chapter.

Getting ready

This hands-on will be using a MS Access report that was imported using Visual Studio in Chapter 4 and hosted on the Report Server. The MS Access report will be modified to use the new Report Items in Report Builder 2.0.

Follow the steps

You will be carrying out the following steps:

1. Open Report Builder and open the ByOrders.rdl report imported in Chapter 4.
   .
2. Review the imported MS Access report.
   .
3. Modify the properties.

Open Report Builder and open the ByOrders.rdl report

You will be accessing the ByOrders.rdl file from the Report Builder in order to modify it in the Report Builder. The steps are listed here:

1. Start Report Builder from its shortcut.
   .
2. Click the Office button and in the drop-down window click on Open.
   The Open dialogue is displayed.
   .
3. Click on Recent Sites and Servers in the left navigation area.
   The Report Servers' URL is displayed.
   .
4. Highlight the Report Server URL and click on the Open button.
   .
5. Click on the MS Access folder and click on the Open button.
   .
6. Highlight the report ByOrders and click on the Open button.
   The ByOrders report gets displayed in the Report Builder as shown: