A dashboard report displays the data in different data regions, on a single display area, to help visualize and analyze the data at a glance. You can use charts, tables, and other controls, along with drill through feature to help design an interactive dashboard report.

What You Will Learn

This tutorial guides you through the steps to create a dashboard report.

• Add a Table Data Region and a TextBox control
• Bind Data to Table Data Region and Add text to TextBox control
• Manage Data in Table
• Customize the Appearance of Report
• Preview and Save Report

After you complete this tutorial, you will have a report that looks similar to the following.

Add a Table Data Region and a TextBox control

To give the report with chart a dashboard look, let us add a table to display the tabular data.  

1. On the design area of the report, drag and drop Table data region  below the Chart data region.
2. To give title to the table, drag and drop a TextBox control   between chart and table as shown.
   

Bind Data to Table Data Region and Add text to TextBox control

1. To fill the table with data,

2. In the details row, drag and drop the Store field on the first column, Region field on the second column, Quantity field on the third column. Also, in the Header row above the details row, enter the labels for the details as shown.
   
   
3. To remove the table footer, right-click the bottom row and select Remove Footer.
   
   To add title to the table,
   
4. Select the TextBox added above the table.
5. Enter the text 'Store, Region, and Quantity'.

Manage Data in Table

1. To group data in table according to the store value,

2. From the Explorer , select the Table data region.
3. Go to Group Editor and select Table1_DetailsGroup1.
4. In the Group Expressions property, click Show Items and then select Add Item.
5. Click the radio button to display the fields and select the Store field.
   
   To obtain the data in the ascending order of store value,
   
6. Select the table.
7. Go to the Sort Expressions property, click Show Items and then select Add Item.
8. Click the radio button to display the fields and select Store field.

Customize the Appearance of Report

See previous tutorials to customize the appearance of the table and the text box to look same as shown.

Preview and Save Report

1. Click Preview  to view your report in the final output.
   You have a chart in which you can drill through to other report, along with the tabular data. 
2. Exit the preview mode by clicking Back on the top left side of the designer.
3. Switch to the File tab and click Save to open the Save dialog box. Enter the report name and click Save Report. You can also provide a description and a revision comment for the report.