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 ?

Group by Top # entered in as Parameter

Background: I have a report that groups by Item number and gives adds
up total amount for that item number. What I want to do is have the
user enter in a numeric value as a parameter such as 10, 15, 20, etc
that will then only display the TOP 10, 15, 20, etc (what they entered
in the parameter) total amounts on the report. Can anyone help me out,
Im sure this can be done but it gets tricky with the parameters thrown
in the mix. Any suggestions is much appreciated. Thanks!hi brent
you can do this w/o issue by using a stored procedure as the source dataset
(and having your 'TOP' value included as one of the parameters).
next, you are going to need to supply a dataset for the dropdown:
select '10' as topval
union
select '20' as topval
union
select '3....
if you plan on 'rolling your own' ASP.NET interface, you can preload the
values for the dropdown in HTML.
Rob
"Brent" wrote:
> Background: I have a report that groups by Item number and gives adds
> up total amount for that item number. What I want to do is have the
> user enter in a numeric value as a parameter such as 10, 15, 20, etc
> that will then only display the TOP 10, 15, 20, etc (what they entered
> in the parameter) total amounts on the report. Can anyone help me out,
> Im sure this can be done but it gets tricky with the parameters thrown
> in the mix. Any suggestions is much appreciated. Thanks!
>