Solved

Reporting Services Limiting No Of rows returned

Posted on 2008-06-14
2
1,517 Views
Last Modified: 2012-06-27
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
Comment
Question by:RamyBouchra
2 Comments
 
LVL 2

Accepted Solution

by:
vasureddym earned 250 total points
ID: 21787922
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
 
LVL 18

Assisted Solution

by:chrismc
chrismc earned 250 total points
ID: 21789973
I believe in the controls filter you can specify TOP too.
But I'll have to check.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question