Creating Matrix in Power Viewer

To summarize your report data in the form of cross-section of fields in rows and columns, you can add matrix to the report.

The following activities can be done on a matrix on Power Viewer.

Showing a field on matrix

A field is picked up from field list and placed as row header, column header or a summary cell.

Available Fields dialog contains fields received from data source.

Figure 26: Available Fields dialog box

To show a field, you need to:

1. Open Available Fields list by clicking  button available on top-left corner of the matrix.

2. Pick the fields to drop on the matrix. On Available Fields, a disabled icon indicates that presently the field is not placed on the matrix. If the text is disabled, it indicates that the field is already placed on the matrix. The field’s location is indicated by colored part of the icon in front of the field name.

3. After picking up the field, place it on either row, column or summary header of the matrix. Click Apply on the Actionboard.
   You can re-position or swap fields by simply drag and drop action on the matrix.

Figure 27: Placing a field on matrix

Getting totals on matrix

1. Hover the mouse pointer on respective column header, row header or summary header.

2. Click  button appearing on the header.

3. Click Show Totals option from the menu. Click Apply on the Actionboard.

4. The report will be refreshed. The refreshed report will have totals.

Changing Function on matrix

1. Hover the mouse pointer on summary header.

2. Click  button appearing on the header.

3. Click Change Function option from the menu and select Avg, Count, etc. Click Apply on the Actionboard.

4. The report will be refreshed.

Filtering on matrix

While viewing a report in HTML Power Viewer, you can filter the report data. Filtering of records is available on character and date fields.

1. Hover the mouse pointer on respective column header or row header.

2. Click Show Filters  button appearing on the header.

3. Click Filter option from the menu. Click Apply on the Actionboard.

4. The report will be refreshed. The refreshed report will have filtered data.

Note: Filtering is not available for numeric fields. For character fields you will get the filter option only if list of lookup values is provided by the administrator.

Hiding a field from matrix

1. Hover the mouse pointer on respective column header, row header or summary header.

2. Click  button appearing on the header.

3. Click Hide Totals option from the menu.

4. The report will be refreshed and the field will not appear on matrix.

Note: You cannot hide a column header if the matrix has only one column header.  It is true for row header and summary cell.

Cancel the drop action

You can remove an operation on the Actionboard. Clicking Clear All removes all the operations on the Actionboard.