Remedy Smart Reporting - How to increase the row limit

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    Remedy AR System Server


    BMC Smart Reporting


    9.0 and above Versions


    How to increase the rowlimit returned by reports in Smart Reporting?


    Default AR Row Limit Will be return by the application


    1. Login with Smart Reporting Admin into client organization (from Remedy ITSM Application Menu flyout)
    2. Go Admin console
    3. Go To Data Source --> ARSystem
    4. Connection Settings
    5. Custom Parameter
    6. At the end of custom parameter add rowLimit ="Limit" Parameter
    For example

    User-added image

    refreshCache=10;DateTimeFormat=MM/dd/yyyy HH:mm:ss a;DateFormat=yyyy-MM-dd

    refreshCache=10;DateTimeFormat=MM/dd/yyyy HH:mm:ss a;DateFormat=yyyy-MM-dd;rowLimit=100000;

    7. Test Datasource and Save

    Run any report to validate rowLimit.

    Please note : We cannot make rowLimit unlimited, there should be some limit that we need to define in Smart Reporting. Increasing AR GetMaxList Row Limit will also help in this case but it might cause performance issues so increasing rowLimit from Data Source will be the optimal solution.

    Article Number:


    Article Type:

    Solutions to a Product Problem

      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles