Steps to apply banding

You can apply banding to a report, a template, or a Grid/Graph on a document.

1. Open the report, template, or Grid/Graph:

   • Open the report in the Report Editor

   • Open the report in the Report Viewer

   • Open the template

   • Open the document, then double-click the Grid/Graph to edit it

2. From the Grid menu choose Options. The Grid Options dialog box opens.

3. Click the General tab.

4. Select the Custom banding option.

5. Click Settings. The Banding Settings dialog box opens.

6. 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.

7. 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.

8. 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.

9. To apply colors to the row values as well as the column values, select Apply banding colors to row values.

10. Click OK. You are returned to the Grid Options dialog box.

11. Click OK. You are returned to the report.

12. Save the report, template, or document to retain your new banding settings.