Symantec Endpoint Management (EPM) Partners Community

By default, reports and dashboards in IT Analytics (hosted by SQL Server Reporting Services) will run automatically when selected. This behavior can sometimes be problematic for environments with excessive amounts of data, resulting in increased load times or timeouts for certain reports. One option to prevent this is to modify the value of a parameter within a report so that it does not execute automatically when clicked, a process which is documented in the article below.

To modify report parameters in more detail in order to load reports more efficiently, please see the article: Modifying IT Analytics Reports to Decrease Load Times.

1. For the purposes of this example we will use the Asset Search report. Note that by default, the report runs with the Asset Type parameter value of 'All' pre-selected.

2. To change this report, open a browser on the server hosing SQL Reporting Services and goto: http://localhost/Reports.
3. From within the IT Analytics folder, locate and hover over the Asset Search report (or the report you want to modify) and to the right you will see a menu of options. Select Manage.

4. Once in the report manage screen, select the Parameters section.

5. Once there, uncheck the 'Has Default' column from the parameter you want to force users to select or enter information on. This will ensure a user must select a value for that parameter before the report can be executed. In this example we will use the Asset Type parameter, then click Apply.

6. Return to the Symantec Management console to load the report and you should notice that it does not automatically execute the report, but instead prompts for a parameter value. Once a value is selected click View Report. Refresh the browser if necessary.