Thursday, November 1, 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

7 comments:

Patricia Pabustan said...

Very good to look at.Thanks..........

Crystal Custom

Dhiman Sarkar said...

This are very nice. I am happy to read it...

Crystal Custom

jannati jahan said...

I love this blog. Thanks for share

Crystal Custom

jannati jahan said...

There's nothing like doing assignments and writing lots of code. C# is the most important emerging language.

http://www.dotnetobject.com/

amar jan said...

When you use a virtual table that was created as a Command, or when you use a Command from the Business Objects Enterprise Repository, Crystal Reports does not alter the syntax of the SQ L submitted to the server

Crystal Custom

Nomita Biswas said...

Crystals have the capacity to absorb, store, amplify, and transfer energy. The healing energy that is transferred by crystals merges into our own energy, lifting us with its high vibration.

Crystal Custom

Dharmendro Bhuyan said...

You'll want to research the latest styles in glasses so that your pick is appropriate for your audience.

Customized sunglasses