June 18, 2009 at 1:36 pm
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.
December 8, 2010 at 2:39 am
Ok I was wondering the same thing
December 8, 2010 at 8:47 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply