10 October 2007

Shade Rows in Crystal Reports

Steve Gray of 4Penny.net has posted a how to for shading rows in a Crystal Report. His example shades every third row gray. It's straight forward enough that you could easily modify it to every other row and change the color to suite your preference. This makes reports a lot easier to follow. I'm not going to give away the surprise, you'll have to visit Steve to see how.

I know that some of you still secretly long for a return to green bar paper. This is your chance to visit that look on others.

As a freebie, you can also easily do this in Excel for that GP Smartlist you've exported with Conditional Formatting.

The formula is:

=MOD(ROW(),2)=0

and you can find out more from John Walkenbach's monster Excel site.

The future's so bright we gotta wear shades.