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>



When in the formula editor, Start out by typing the first charter of the function, press Ctrl-Space. The keyword auto complete will than show a list of the functions available beginning with the charter you typed in.