Setting Report/Data Size limit in SSRS 2008

  • Has anyone had any experience with limiting the amount of data that a report can return? My company was exploring the option of setting a default maximum date range for all reports but after some investigation we determined it would make more sense to set a default cap on the amount of data a report can return to a user. I have seen the reportserver.config option to set the DatabaseQueryTimeout but I was wondering if anyone knew of a way to limit the actual size/amount of data coming back thru the pipe other than filtering on the database side. Basically, if the limit size is X and the report dataset is Y and X < Y, return a message to the user to run the report with different parameter values to return a smaller dataset.

  • Ok I was wondering the same thing

  • In Report Builder, you can remove duplicate data or filter formulas.

    But I think the only way to truly limit the total data set is to set up a where clause in the original sql statement, by way of using the Row_Number function perhaps.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply