BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

Shading every other line of the detail section

To shade every other line of the detail section of the report

1. Start by opening up the Section Expert by clicking on Go to Report, Section Expert.

2. Highlight the Details section on the left. 3. Click the Color tab in the upper right. 4. Click the X+2 button and enter the following in the editor:

If Recordnumber Mod 2 = 0 Then Color(239,239,239) Else crWhite

5. Save and close.

In the example below the color function is used to return a specific shade of gray. CrGray, or crSilver can be used. Adjust the values in the color function. For gray, keep all the numbers the same, and increase them for a lighter shade, or decrease them for a darker shade.

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



Use the Chart Sort Order dialog box to sort and group your chart data. This dialog box appears when you click the Order button on the Data tab of the Chart Expert for a chart with the Advanced layout type.