Interactive SSRS Reports: User-Friendly Filtering and Parameter Management

• SSRS reports typically run automatically if all report parameters have default values.
• These default values essentially pre-populate the parameters, causing the report to execute with those predefined values.

Solutions:

1. Remove Default Values:
   • Open the report in Report Builder.
   • Go to the Report Properties (right-click on the report name in the Solution Explorer).
   • Under the Parameters tab, select each parameter and uncheck the "Has Default Value" checkbox.
   • Save the report.

Example:

Imagine a report that filters data based on a "Date" parameter. By default, if the parameter has a pre-selected date (2024-02-28), the report will automatically fetch data for that day when opened. Removing the default value forces the user to choose a date before running the report.

1. Use Hidden Filters:
   • If your report relies on filters with default values, consider making them hidden by default.
   • In Report Builder, right-click on the filter and select Visibility.
   • Choose Hidden from the options.
   • Users can then unhide the filter and modify it before running the report.

Related Issues:

• Allowing Null Values: Ensure the "Allow null value" option is not checked for optional parameters. This can also trigger automatic execution when the report opens.
• Subscriptions and Caching: If the report is part of a subscription, it will still run automatically at the scheduled time regardless of the above settings. Consider adjusting subscription schedules or implementing caching mechanisms to manage data retrieval frequency.