- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
TWO WAYS TO CREATE ALTERNATING COLOURS IN SSRS
Part one of a three-part series of blogs
A common requirement for Reporting Services reports is to colour alternate rows. This blog gives two approaches, one of which uses custom assemblies.
- Alternating Colours in Reporting Services Tables (this article)
- Alternate Colours using Conditional Formatting
- Alternate Colours using a Custom Assembly
Alternating Colours in Reporting Services Tables
This blog shows how you can create alternate colours in a report, using a simple way (which sometimes works), and then a more complicated (but more reliable) way. I'm intending it as a practical example of the use of custom assemblies.
The effect we're trying to achieve.
The rest of this blog is split into 2 parts: a simple way to create alternate colours using conditional formatting, and a more complicated way using a custom assembly.
TWO WAYS TO CREATE ALTERNATING COLOURS IN SSRS
Part one of a three-part series of blogs
A common requirement for Reporting Services reports is to colour alternate rows. This blog gives two approaches, one of which uses custom assemblies.
- Alternating Colours in Reporting Services Tables (this article)
- Alternate Colours using Conditional Formatting
- Alternate Colours using a Custom Assembly
Comments on this blog
This blog has 2 comments:
If I'm trying to alternate the colours for group header rows (useful with drill downs / outlining), I've used something like this:
=IIF(RunningValue(Fields!fieldname.Value, COUNTDISTINCT, NOTHING) MOD 2 = 0, "Gray", "White")