Thursday, 8 May 2014

Shade Alternate Lines


Repost from Crystal Report Tips and Trick  This was very useful and simple.

Shading Alternate Details Lines

  1. Right-click the Details section name.
  2. Select Section Expert.
  3. Click the color tab and click the Conditional Formatting button.

  4. To shade every other line, enter the formula
    If RecordNumber Mod 2 = 0 Then crSilver else crNoColor
    To shade every two lines, enter the formula
    If RecordNumber Mod 4 in 1 to 2 Then crSilver else crNoColor
  5. Click OK twice, and preview your report.

No comments:

Post a Comment

Samsung Android Keyboard

  If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and ...