D J Horton Consulting Ltd

Personal reference to useful tips and tricks for SQL Server, SQL Server Reporting Services and Crystal Reports.

My alternative to scraps of paper lying about.

Friday, 21 August 2009

Green bar report - CR

If(RecordNumber Mod 2=0)
then crGreen
else DefaultAttribute

Note: Record Number can be replaced with GroupNumber to alternate Group row colours


Anonymous said...

Hello Dom! How would I do green bar formatting in a Crystal or RS cross tab report?

Dom Horton said...


Please have a look at this post:


Greg said...


Sorry for not posting my name w/the question. I was in a hurry and don't have any of the profiles listed, so I just chose anon. Thanks for posting the SSRS matrix/crosstab solution. I'm sure it'll come in handy when I re-fromat my reports. Looking forward to the Crystal version too!


Dom Horton said...

SQL Server Reporting Services Green Bar Report