Currently, the system runs a query to check number of records and output following error message if the query result is more than 100,001.

"Running the report has been cancelled due to the time it will take to run. Adjust the parameters of the report and retry"

There are date range parameter in the report parameter but date range is not considered to record counting. Because of this, users cannot output report even though they specified the date range for one month.

The customer requested to add date range criteria to the query for checking number of records.