Crystal Reports How-To: Alternating Background Colors

Unlocking Efficiency with NetSuite Field Service Management

From William Schlageter, Lead Software Developer

If you have a Crystal Report that has a lot of detail lines, it can be hard to distinguish between the different lines.

Here is a way to add an alternating background color to you report.

Right-click on the Details section and select “Section Expert…”.

 

Click on the Color tab.

Click the formula button (the blue “x 2” button).

Type in the following formula:

if (RecordNumber mod 2)=0 then crSilver else crNoColor

Click “Save and close”.

Click OK.

Now when you preview the report, you will find the report has a silver background for each even row.

If you need help with your Crystal Reports or additional training, contact Oasis Solutions Group. Oasis offers custom programming, development and training for basic and advanced Crystal Reporters users.

 

You may also like

Oasis Solutions is proud to be recognized as the Fall 2025 NetSuite Solution Provider Spotlight Winner in the Automotive Industry ...
Oasis Solutions is honored to be named to Accounting Today's 2025 Top 100 VARs list—recognizing excellence in ERP and accounting ...

Stay tuned on our ERP path!

Subscribe to our newsletter and get the latest news