Selecting a Data Drill View for the Report Viewer
  • Updated on 09 May 2013
  • 2 minutes to read
  • Print
  • Dark
    Light

Selecting a Data Drill View for the Report Viewer

  • Print
  • Dark
    Light

Report data in a Report Viewer can be summarized in a variety of formats.  This customization allows users to select the Data Drill View they wish to utilize when the Portal Page is viewed. 
Example
The goal of this example is to:

  1. Create a portal page, and add a Report Viewer to it.

  2. Set the default report to display in the Report Viewer .

  3. Select the desired View Mode options.

  4. Select the Data Drill View mode, and view the results in the Report Viewer .

To begin, navigate to a Designer Folder and select Manage > Page > Add Page .
2018-07-10_090324-14.jpg

In the resulting dialog, name the page and click CREATE .
2018-07-10_094020.jpg

From the Page Elements , expand the Reports category and drag a Report Viewer component into the workspace.
2018-07-10_094231.jpg

To set the report to be displayed when the user opens the page click the Default Report selector button found in the Behavior section of the Properties Panel .
In the resulting Pick Entity dialog, select the desired report and click PICK .
2018-07-10_094419.jpg

Now that a report has been selected, the data drill settings can be changed.
In the Properties Panel go to the View section and select the desired output options from the View Mode list.
Note: to use the Calendar , Charts , and Matrix options, the report selected must be configured with these options.
2018-07-10_094717-1.jpg

Also in the View section, the user can select the Data Drill View from the items in the drop down list.  This sets the view mode to be displayed when the user drills down into a report.
The page is now complete.  Save it and close the Page Designer .
2018-07-10_094928.jpg

To view the report, click on the page’s thumbnail and select View > Preview Page from its Action menu.
2018-07-10_095104.jpg

The report opens in a new window and is displayed in one of the selected output options.  By default, if Data is selected, the report will always be displayed in the grid view mode.
2018-07-10_095142.jpg

To change the output view mode, select the corresponding View Mode icon found top left of the Report Viewer
2018-07-10_095421.jpg

Once the View Mode has been selected, clicking on an individual entity in the report allows the user to drill down into the report.  The information regarding the entity is displayed in the Data Drill View mode selected in the Page Designer .  Notice, the user can manually change the drill down view by selecting one of the available buttons at the top left of the pop-up window.
2018-07-10_100027.jpg

Selecting other report view modes will give the user the same option to drill down into the report.
2018-07-10_100107.jpg

Again, the data is displayed in the format configured in the Page Designer , but the user has the option to change the view manually.
2018-07-10_100148.jpg

Was this article helpful?