Use this Reporting Services page in SQL Server Management Studio to set limits on the report execution data that is collected by a report server. Execution data is stored internally in the report server database. You can track report activity for report server that runs in native mode or SharePoint integrated mode. If the report server is part of a scale-out deployment, the report execution log maintains a record of all report activity for the entire deployment in a single log file.
To open this page: 1) Start SQL Server Management Studio 2) Connect to a report server. 3) Right-click the report server name and select Properties. 4) Click Logging to open this page.
Enable report execution logging
Click to create and store information about report activity on the server. If this option is enabled, the report server will track which reports are used, the frequency of report processing, the type of report operation that was performed, the output format, and who ran the report. For more information about additional data points that are captured in the log, see Report Server ExecutionLog and the ExecutionLog3 View.
Remove log entries older than this number of days
Specify the number of days after which log entries will be trimmed from the report execution log. The default value is 60 days.
Set Report Server Properties (Management Studio)
Connect to a Report Server in Management Studio
Reporting Services Log Files and Sources
Report Server in Management Studio F1 Help
Report Server ExecutionLog and the ExecutionLog3 View