Display only top 20 rows in a group in a table

How do I display only the top 20 rows in a group in a table? I tried using
RowNumber but must have done something wrong. It was working on the data as
a whole, not on the group-specific counts. Thanks.
StephanieWhen you used the RowNumber, did you specify the scope as the Group name?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:718A51DF-441A-4AD4-A992-528A64707F45@.microsoft.com...
> How do I display only the top 20 rows in a group in a table? I tried
> using
> RowNumber but must have done something wrong. It was working on the data
> as
> a whole, not on the group-specific counts. Thanks.
> Stephanie|||Andy,
Thank you very much! You were exactly correct. I was able to get it to
work changing the Hidden Visibility value of the row to:
=Iif(RowNumber("table1_Group1") > 20,True,False)
Stephanie
"Andy Potter" wrote:
> When you used the RowNumber, did you specify the scope as the Group name?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:718A51DF-441A-4AD4-A992-528A64707F45@.microsoft.com...
> > How do I display only the top 20 rows in a group in a table? I tried
> > using
> > RowNumber but must have done something wrong. It was working on the data
> > as
> > a whole, not on the group-specific counts. Thanks.
> >
> > Stephanie
>
>