Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

244



LESSON 27 Building a dashBoard

Step-by-Step

1. Open the BI Trainer Reports project that you created in the previous chapters of this section

of the book.

2. Right-click the Reports folder in the Solution Explorer and select Add  Existing Item.

3. Select the Dashboard.rdl file included with the download for this lesson at www.wrox.com.

4. Right click the Reports folder in the Solution Explorer and select Add  Existing Item again.

5. Select the StateDetails.rdl file included with the download for this lesson at www.wrox.com.

6. Double-click the DashBoard.rdl file in the Solution Explorer to open the report. Notice that

the two tables are already completed because tables were covered in a previous chapter.

7. To add the drill-down to the table, right-click the State column data row in the left table and

select Text Box Properties.

8. Click the Action node on the left.

9. Click the radio button next to Go to Report.

10. Select StateDetails from the Specify a Report drop-down menu.

11. Click Add.

12. Select State in the Name drop-down column.

13. Select [State] from the Value drop-down menu.

14. Click OK.

15. Repeat Steps 7 through 14 to add the same drill-down action to the table on the right. The

screen should look like the one in Figure 27-6.

16. Drag a chart from the Toolbox to the space below the tables.

17. Select the column chart in the top left of the ...