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

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...