MicroStrategy ONE
Steps to apply banding
You can apply banding to a report, a template, or a Grid/Graph on a document.
-
Open the report, template, or Grid/Graph:
-
Open the report in the Report Editor
-
Open the report in the Report Viewer
-
Open the document, then double-click the Grid/Graph to edit it
-
-
From the Grid menu choose Options. The Grid Options dialog box opens.
-
Click the General tab.
-
Select the Custom banding option.
-
Click Settings. The Banding Settings dialog box opens.
-
To create horizontal bands, select By rows as the Banding preference. Then choose one of the following options for the Banding criteria:
-
By number of rows: Specify the following settings:
-
Apply first color every __ rows specifies the number of bands of the first color that will be put on the grid horizontally.
-
Apply second color every __ rows specifies the number of bands of the second color that will be put on the grid horizontally. The two colors are used alternately.
-
By row header: Choose the desired header from the list. The horizontal bands on the grid are colored according to the groupings on the selected row.
-
-
To create vertical bands, select By columns as the Banding preference. Then choose one of the following options for the Banding criteria:
-
By number of columns: Specify the following settings:
-
Apply first color every __ columns specifies the number of bands of the first color that will be put on the grid vertically.
-
Apply second color every __ columns specifies the number of bands of the second color that will be put on the grid vertically. The two colors are used alternately.
-
By column header: Choose the desired header from the list. The vertical bands on the grid are colored according to the groupings on the selected column.
-
-
You can specify the two colors to be used for banding in the Banding colors box. For each color, click the drop-down arrow to access a palette of color options.
-
To apply colors to the row values as well as the column values, select Apply banding colors to row values.
-
Click OK. You are returned to the Grid Options dialog box.
-
Click OK. You are returned to the report.
-
Save the report, template, or document to retain your new banding settings.