January 10, 2014 at 1:30 am
We have been asked to display a warning message to the user when the # of records in the report exceeds 250,000 records, i.e. if the result set in the report exceeds 250,000 row count and the user tries to export the report to Excel format by clicking on the "Export" link button.
In SSRS, can we set the the limit value (250,000) on the row count? and how can we display the message when result set is > 250,000?
January 10, 2014 at 1:40 am
This is not easy to do.
How are users accessing the reports?
You can build your own asp.net pages which display the reports and then you can do what you want, but natively SSRS doesn't really support this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 10, 2014 at 2:03 am
Use Top (250,000) in your report query, have a count of records and expression to display text showing maximum records reached
SQL 2000/2005/2008/2012 DBA - MCTS/MCITP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply