How to use the Top N in Filters

Hi,
I have created one report which uses the stored proc. it returns the data
more than 100 rows but i want to show only top 20 records in the graph( I
have to use that stored proc only. not possible to create another stored
proc)..
How can i achieve that? I found one property at filters sections i.e Top
N. Could any one let me know the usage of TOP N.
Regards,
SriHope you have used table control, just right click for properties. select the
filter tab In the expressions select the first column of your dataset. Select
the "Top N" from the operator. now in the value just type =20. You get first
20 rows.
Amarnath
"Sriman" wrote:
> Hi,
> I have created one report which uses the stored proc. it returns the data
> more than 100 rows but i want to show only top 20 records in the graph( I
> have to use that stored proc only. not possible to create another stored
> proc)..
> How can i achieve that? I found one property at filters sections i.e Top
> N. Could any one let me know the usage of TOP N.
> Regards,
> Sri