Oasis Solutions Blog

Crystal Reports How-To: Alternating Background Colors

Written by Oasis Solutions | Mar 4, 2015 7:57:45 PM

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.