Configuring a Data Grid in the Report Builder

You can add a data grid component to a report.

Before You Begin

• Build a report using a Data Cube dataset.

• To build and deploy reports, your CommCell user account requires a role with the Add Report permission and an association with the CommCell entity.

  For more information about users, permissions, and associations, see User Administration and Security - Overview.

Procedure

1. On the Web Console for the Private Metrics Reporting Server, click Reports.

   The Worldwide Dashboard appears.

2. To open a report that you already added a cube data set to:

   1. From the navigation pane, click Configuration > Reports.

   2. In the row for the report that you want to open,in the Actions column, click Edit.

3. If your report has multiple pages, click the tab for the page that you want to edit.

4. From the Visualization tab, drag the Data Grid component into the Drop components to build the report box.

5. To add a field, from the Data Sets list, drag the field into the data grid component box.

6. To configure data grid settings, select the data grid, on the Properties tab, click General , and then enter the following information:

   1. In the Title box, enter a title for the tree grid component.

   2. In the ID box, type a new identifier.

   3. To include all columns in the report, select the Include All Columns check box.

   4. To hide a grouping header in the data grid component, clear the Show grouping header check box.

   5. To allow users to select only one row, select the Row Selection check box.

   6. From the Visible list, select who can view the component:

      • All: To allow everyone see the component, select this option.

      • CommCell Admin: To allow only CommCell administrators see the component, select this option.

      • Tenant Admin: To allow only only tenant administrators see the component, select this option.

      • Custom: To allow users see the report based on the permissions, select this option, then in the Visible Expression box, enter a JavaScript statement.

      • For example, to allow MSP users see the component, in the Visible Expression box, enter := return cv.isMspUser.

7. To configure columns, do the following:

   1. On the Properties tab, click Fields .

   2. Expand Columns, and then go to column_name.

      For information about how to configure columns, see Configuring Columns in the Report Builder.

8. To save this version of your report specification in the Reports Manager, at the top of the Report Builder page, click Save.

9. To make the report available to end users on the Reports page, at the top of the page, click Deploy.