Coloring Every Other Row in a Report
This procedure describes how to enhance the readability of a report by adding alternating rows of color. It begins by creating a simple MultiTab dive window, converting the window using a default report style, and then configuring options in the Report Preferences and Edit Item, Border dialog boxes.
Complete the following steps:
-
Select a server with a project that contains a sales model with dimensions and summaries, such as:
- Supplier, Brand, and Ship Month
- Cases, Revenue, and Cost
For illustration purposes, this procedure refers to a sales model called sales_90day.
-
In ProDiver, locate and open sales_90day.mdl.
-
On the Console, double-click Supplier to open a basic tabular dive window.
-
Click the MultiTab icon.
-
On the Console, double-click Brand to open a
MultiTab dive window. - Click the Report icon to open the
Default Report dialog box. -
Perform the following steps:
- On the Report Style box, select Indented 2 Level MultiTab.
-
If selected, clear the Gridlines check box.
- Click OK to display the sample MultiTab report.
- Click the Lock icon to unlock the report.
- Click the Preferences icon to open the Report Preferences dialog box.
- Set the Space between Columns option to 0, and click OK.
- Select the row values for the Brand column, and press Shift+Click to select the row values for the Cases, Revenue, and Cost columns.
-
Right-click one the highlighted sections, and select Edit Item to open the
Edit Item dialog box. - Click the Border tab and perform the following steps:
- Click Select and choose Green as the background color.
- Select Every Other Row.
-
Click OK to
set the background color of every other row to green.