Jump to content
We've recently updated our Privacy Statement, available here ×

  • mgeise
    • Features: Ad Hoc Product: JasperReports® Server


    [toc on_off::hide=1]

    When Ad Hoc Dataset contains more than 200,000 rows, exception is thrown: "The query for the report has been canceled because it returned more than 200000 rows. Modify the report to reduce the number of rows"


    For performance reasons Ad Hoc Dataset Row Limit is set to 200000 by default.


    There are two ways to change this value: temporary and permanent.

    Temporary Solution (reset on server restart)

    NB: on server restart the value would revert to default.

    • Login as Superuser.
    • Go to Manage -> Ad Hoc Settings
    • Set "Ad Hoc Dataset Row Limit" to desired value.

    Permanent Solution

    You can permanently increase this limit by editing applicationContext-semanticLayer.xml file under WEB-INF directory and change the settings to a larger limit to accommodate your needs:

    • go to the bottom of the file and locate the bean property

    • change the limit value for the setting bellow (default setting is 200000):

    • save the change, restart your server and run the report again.

    11:21, 6 December 2011 (UTC)


    User Feedback

    Recommended Comments

    There are no comments to display.

    This is now closed for further comments

  • Create New...