Report Builder - Professional SQL Server 2005 Reporting Services - page 379

Now that you have accessed the Order Date field from the Report Model, you can add Year to the
columns of your report. In the field list you will see a number of different attributes that define Order
Date. One of those attributes is the Calendar Year. This breakdown was defined when the Report Model
was created and allows the user to easily use different date variations in their reports. To add Calendar
Year to the report, click on the Calendar Year field and drag it to the report designer area labeled “Drag
and drop column groups,” as illustrated in Figure 9-10.
The final item you need to add to the report is a data element to total. In this scenario, you are using
Total Sales Amount from the Reseller Sales entity. After adding the Calendar Year field to the report, the
Explorer displays all of the other attributes related to Fact Reseller Sale in the field list. Select Total Sales
Amount and drag and drop it on the report area labeled “Drag and drop totals.” Once you have added
the final field, you should see a report layout similar to the one in Figure 9-11.
Figure 9-10