Web Designer
Get Started / Tutorial 6: Create Report with Chart / Tutorial 6.3: Create a Dashboard Report
In This Topic
    Tutorial 6.3: Create a Dashboard Report
    In This Topic

    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.

    Note: You need to complete Tutorial 6.2: Create Report with Drill-through in Chart before performing following steps.

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

    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 Table Toolbar Icon below the Chart data region.
    2. To give title to the table, drag and drop a TextBox control Textbox Toolbar Icon  between chart and table as shown.
      Adding table data region and textbox data region to the report

    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. The Header row above the details row is automatically filled with labels.

      Binding Data to Table Data Region
    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 Report Explorer Icon, 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.
    Customized Dashboard Report

    Preview and Save Report

    1. Click Preview Preview Button 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. Click Save to open the Save dialog box. Enter the report name and click Save Report.
    See Also