Monday, December 2, 2013

Crystal Reports : Alternating Background Color

Ah, such an oldy and goody! Did you know you can leverage the section formulas in Crystal to mimic an old-school printout format of alternating colors per row?


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

2 comments:

lin liyi said...

In case you have also been looking forward intended for application replica prada leather that may definitely provide what you need, subsequently it truly is time period you will get that state-of-the-art in addition to innovative application. A couple connected with the fake gucci usually are into your small business connected with telephone focuses and in addition they include fitted that application with regards to telephone focuses. By what exactly many people look at that offer, I could truthfully think it's definitely sensible application having a great number of gucci replica handbags. There're rather delighted at this point while using the offer of which permitted those to save money; lower time period, in addition to raise telephone time period answer. This impressive Vocalcoms clutches Fox were being tried in addition to okayed by means of Avayas Programmer Network method in addition to ıt had been located which the offer received impressive alternative that had been made to help use many the use of the two of these answers of which cheaper managing price tag, strengthen support services in addition to raise production. Vocalcoms louis vuitton replica handbags bundled having delivers end users in addition to callers finish probability to systematize in addition to take care of various call-centers within just one exclusive web page. This can be the almost all entire alternative intended for replica birkin hermes intended for many position telephone focuses.

林磊 said...

2016-2-20 leilei
jordan retro 8
christian louboutin uk
air jordan 4
burberry outlet
ralph lauren outlet
air max
louis vuitton
tiffany and co
ugg outlet
oakley sunglasses
jordan retro 4
coach outlet online
ray ban sunglasses
oakley sunglasses
nike store uk
coach factory outlet online
michael kors handbags
coach factory outlet online
nike huarache
toms outlet
canada goose jackets
ugg boots
louis vuitton borse
burberry outlet
air jordan 8
chaussure louboutin
canada goose jackets
nike outlet
nike trainers
longchamp le pliage
louboutin outlet
montblanc pens
toms shoes
christian louboutin
ray bans
burberry scarf
michael kors bags
nike sb dunks
cheap jordans
pandora charms