[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1523
  • 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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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