group expression

Hello, I am very new to Reporting Services and want to do something I have
done in other programs using a tool or wizard. I want to group my data by "
30 days over due" , then " 60 days over due" etc..Based on the following
DAYSDUE > 30 and < 60
DAYSDUE > 60 and < 90
DAYSDUE > 90 and < 120
DAYSDUE > 120
I think it will need to be an expression in the group dialog box, but for
the life of me I cant's seem to come up with it. Any help would be
appreciated. ThanksTry this:
=iif(Fields!Daysdue.Value > 120, 1, iif(Fields!Daysdue.Value > 90, 2,
iif(Fields!Daysdue.Value > 60, 3, iif(Fields!Daysdue.Value > 30, 4, 5))))
The expression basically maps the integer values to five distinct groups: 1,
2, 3, 4, 5
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"SLB" <SLB@.discussions.microsoft.com> wrote in message
news:D262B295-7A20-45F0-B6A4-1ADC448FD970@.microsoft.com...
> Hello, I am very new to Reporting Services and want to do something I have
> done in other programs using a tool or wizard. I want to group my data by
> "
> 30 days over due" , then " 60 days over due" etc..Based on the following
> DAYSDUE > 30 and < 60
> DAYSDUE > 60 and < 90
> DAYSDUE > 90 and < 120
> DAYSDUE > 120
> I think it will need to be an expression in the group dialog box, but for
> the life of me I cant's seem to come up with it. Any help would be
> appreciated. Thanks
>