Limit table rows

How do I limit table rows in a report, right now it shows all rows and that
makes it difficult to see what the columns are.
SQL 2000
----
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 40320 spam-mails
Betalende brugere får ikke denne besked i deres e-mails.
Hent en gratis SPAMfighter her.On Feb 19, 4:24 pm, "CRM Master" <no_s...@.spam.com> wrote:
> How do I limit table rows in a report, right now it shows all rows and th=at
> makes it difficult to see what the columns are.
> SQL 2000
> ----=--
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at f=E5 40320 spam-mails
> Betalende brugere f=E5r ikke denne besked i deres e-mails.
> Hent en gratis SPAMfighter her.
You should adjust your query by using 'Top(number of rows).'
If you are referring to report columns, you can limit the number of
records per column by selecting the 'Edit details group' (if you're
using a label), below 'Group on:' and 'Expression' enter
=3DCeiling(RowNumber(Nothing)/18) where 18 can be changed to number of
records per column. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer