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

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...