Monday, June 4, 2012

Crystal Reports : Alternating Background Color

To make a report easier to read, you can alternate the background color to help different lines stand out. (Think of the old green and white striped paper you used to put in your tractor printer years ago)

To make this happen, we will need to format the Details Section of our report.

Step #1 : From the top-level menu, select Format Section.
Step #2 : Select the "Detail" section on the left hand side.
Step #3 : Click on the "Color" tab on the right hand side.
Step #4 : Click the [formula] button with the "x-2"on it to bring up the formula editor.
Step #5 : Paste in the following : if RecordNumber mod 2 = 0 then crSilver else crNoColor

This will alternate a white and silver background for each row printed.

Pro Tip : To alternate color for Group rows, paste the following into the Group section color formula: if GroupNumber mod 2 = 0 then crSilver else crNoColor

3 comments:

Anonymous said...

So how do I use this formula for alternating the color of my groups when 1 of the groups is hidden? Thanks

Zheng junxai5 said...


zhengjx20160623
cheap rolex watches
fitflops
timberland outlet
coach outlet online
toms wedges
true religion jeans
replica rolex watches
ralph lauren outlet
kate spade outlet
michael kors outlet
cheap jordan shoes
michael kors outlet clearance
coach outlet store online
fit flops
christian louboutin shoes
nike air huarache
coach outlet
timberlands
concords 11
ralph lauren home
toms wedges
retro jordans 13
burberry outlet
cheap jordans
gucci outlet
coach factory outlet online
abercrombie outlet
cheap air jordans
lebron 12
coach outlet online
tory burch boots
hollister clearance
cheap oakley sunglasses
nike free uk
louis vuitton outlet stores
louis vuitton outlet online
michael kors outlet
supra footwear
nike uk
michael kors outlet online

Fangyaya said...

ugg boots
polo outlet
ray ban outlet
true religion outlet
ugg uk
cheap air jordans
adidas stan smith
coach factory outlet
uggs on sale
adidas trainers
michael kors outlet online
christian louboutin pas cher
nike air max pas cher
ray ban sunglasses outlet
fitflops sale
nike air max uk
red bottom shoes
michael kors outlet
uggs outlet
ralph lauren clearance
tory burch shoes
ralph lauren
toms shoes
cleveland cavaliers jerseys
adidas yeezy
louis vuitton purses
adidas outlet store
christian louboutin outlet
nhl jerseys
ugg boots
cheap rolex watches
hermes birkin handbags
michael kors purses
cheap louis vuitton handbags
nba jerseys
ugg outlet
toms shoes outlet
uggs on sale
replica rolex watches
cheap uggs
20168.13chenjinyan