Group Format

Hi,
I want to set my group's background to different color. something like
Group1
[Group1-A] [BGColor=Blue]
[Group1-B] [BGColor=Green]
[Group1-C] [BGColor=Red]
Group2
[Group2-A] [BGColor=Blue]
[Group2-B] [BGColor=Green]
[Group2-C] [BGColor=Red]
any clue ?You can use an expression to set the group's background color. You have two
choices: iif() or swtich().
The iif() syntax is a resonable choice when there are a couple of options.
Switch() will be easier if you have a large number of options.
=iif(Fields!<FieldName.Value> = "Value1", "Green", "Blue")
=Switch(Fields!<FieldsName>.Value = "Value1", "Green",
Fields!<FieldsName>.Value = "Value2", "Blue", ...)
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ameet" <Ameet@.discussions.microsoft.com> wrote in message
news:1008088F-1FC6-4625-9C1A-EF4096D0FB0C@.microsoft.com...
> Hi,
> I want to set my group's background to different color. something like
> Group1
> [Group1-A] [BGColor=Blue]
> [Group1-B] [BGColor=Green]
> [Group1-C] [BGColor=Red]
> Group2
> [Group2-A] [BGColor=Blue]
> [Group2-B] [BGColor=Green]
> [Group2-C] [BGColor=Red]
> any clue ?