Crystal Reports How-To: Alternating Background Colors

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

5 Advantages to choosing Oasis Solutions as your NetSuite Solution Provider  NetSuite is considered the #1 cloud ERP in the ...

In 2024, we’re living in the future. Pocket-sized AI and portable workspaces have shown us that finding balance at work is as ...

Stay tuned on our ERP path!

Subscribe to our newsletter and get the latest news