• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1525
  • Last Modified:

Reporting Services Limiting No Of rows returned

Dear EE
I am working with Reporting Services 2005 and I want to limit the number of rows inside the report with either tabular report or Matrix report
How can I do that?
Please advise me what to do.
Thank you,
0
RamyBouchra
Asked:
RamyBouchra
2 Solutions
 
vasureddymCommented:
1) if you are using a query in report, then you can use TOP clause to return the record set
2) if NO, then i'll have to think
0
 
chrismcCommented:
I believe in the controls filter you can specify TOP too.
But I'll have to check.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now