Client Management Suite

 View Only
Back to discussions
Expand all | Collapse all

50,000 Row Limit on report output

  • 1.  50,000 Row Limit on report output

    Posted Jul 13, 2011 05:06 PM

    There is a default limit of 50,000 rows returned from a report.  There is a KB article here that shows how to get around this for specific reports - the instructions are to include "set rowcount 0" in your report's SQL.  That was fine in NS 6, but it doesn't appear to work in NS 7.1 SP1.

    Is there a similar way to remove this limit for specific reports ?  I need to dump some 500,000 rows to a flat file for integration with another system.



  • 2.  RE: 50,000 Row Limit on report output

    Posted Oct 19, 2011 10:29 PM

    Thanks to Mr Magoo, this is now a feature request :-)