Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A wise person learns by the experience of others. An ordinary persons learns by his or her own experience. A fool learns by nobody's experience
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

04
August

How Do I Create a Banded Report with Grouped Tables

During a recent training course a delegate asked "How do I create a banded report in a grouped table?"

If one creates a banded report in a Tablix using the usual formula everything is fine, however if there is a grouping in that table, things tend to get a little bit interesting!

Solution:

To get around this one can apply this formula to the details row od the Tablix:

=IIF(RunningValue(Fields!Category.Value,CountDistinct, Nothing) MOD 2 = 1, "Colour1", "Colour2")


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
1

Bob

08
October
Heya i am for the primary time here. I found this board and I in finding It really helpful & it helped me out a lot. I hope to provide one thing again and help others like you aided me.

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

95 + 45 =