CODEWITHSUNDEEP
reporting-servicesparametersrefreshreporting
Javi
Javi

Reputation: 23

Can I add autorefresh to SSRS report only when parameters change?

Imagen

I have this report in SSRS, how can I Add autorefresh by code only when parameters change by User (Without clicking red button)

Upvotes: 0

Views: 1432

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

YOU CAN'T

have the report automatically update after the user changes a parameter. There's no functionality built in for the parameters.

BUT YOU CAN

create your own parameter selection inside the report body that the user can click on and will rerun the report.

For this report, the Rate parameter would be hidden.

A table with one column is added to the report with the Rate parameter data as the table's source and the Rates as the detail value.

An ACTION is added to call the same report and populate the Rate parameter with the Rate field from the new Rate table.

When a user clicks on a row in the new parameter table, the report action will rerun the report using the click-on value for the Rate.

enter image description here

Upvotes: 1

Related Questions