Reports - Restrict the date range of MMS report

Requirement

In the last couple of EOMs we have seen issues where long running reports have caused the whole system to slow down. The latest issue was due to a user selecting a date range of 3 years.

We would like to investigate restricting the available date ranges for those reports that run for a range.

The restriction can be something as simple as throwing up a popup informing the user that they have selected a data range that is too great, and then direct them back to the report paramteers.

• In other words no need to get clever with restricting the dates available for selection.

I have created a story, per report group, to investigate and make changes as necessary.

Also, these changes will need to go back in 2020R1.

CFA have asked that data be available for 13 months, but I am not sure that we actually need to support a date range of 13 months, maybe a smaller range.

• Is it possible to determine the typical and max date ranges that each report has been run for?
• Can we make a data based decision?
• reporting services executionlog - Lucas will need to grant access to the Reporting Server in order to see this