Selecting a Data Drill View for the Report Viewer

Last Updated: 08/17/2016 Introduced in Verision: 2.0

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 click the Create Page/Dashboard button.

createPage

 

In the resulting pop-up window, name the page and click Ok.

namePage

 

From the Toolbox Panel, expand the Reports category and drag a Report Viewer component into the workspace.

dragReportViewer

 

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.

 reportSelector

In the resulting Picker pop-up window, select the desired report and click Ok.

 pickReport

Now that a report has been selected, the data drill settings can be changed.

In the Properties Panel, in the Behavior section 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.

views 

Also in the Behavior 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.

 drillView

The page is now complete.  Save it and close the Page Designer.

 savePage

To view the report, click on the page’s thumbnail and select View > Preview Page from its Action menu.

 previewPage

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.

 reportOpensinDataView

To change the output view mode, select the corresponding View Mode icon found top left of the Report Viewer. 

 tilesMode

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.

 dataDrillTiles

Selecting other report view modes will give the user the same option to drill down into the report.

 chartsView

Again, the data is displayed in the format configured in the Page Designer, but the user has the option to change the view manually.

dataDrillCharts

 

Additional Resources