How to give every section on a summary report a different color like a rainbow.

[former_member597308]

I have a report grouped by state and we want the report to have a different color for each group (STATE) sort of like a rainbow.

Using crystal reports 2016

[abhilash_kumar · Accepted solution]

Hi Joe,

You can use a random number generator to automatically color a section.

Go the Section Expert > Highlight the Group Header > Color tab > Click the formula button beside Background color > Use this code:

Color(int(rnd(1)*200), int(rnd(1)*150), int(rnd(1)*140))

You can change the multiplication factors above to a smaller number to change the shades.

-Abhilash

[former_member597308 · Accepted solution]

Thanks I found another way but your makes more sense and appears easier but I would not have thought of it.