Paginated Reports Back Navigation Fails When Multi-Value Parameter Uses Select All

What’s happening is that Select All is not stored as the full explicit list of values. When you navigate to the subreport and then use the Back button, Report Builder tries to re-validate the parameter using a stale or incomplete value set, which causes the validation error. When you manually select values, the parameter contains an explicit list, so validation succeeds.

Practical workarounds:.

• Use a custom “All” value (e.g. -1) and handle it in the dataset query instead of the built-in Select All.

• Convert the parameter logic to explicitly expand “All” into all values in the dataset.

WHERE
(
    @MyParam = '-1'
    OR MyColumn IN (@MyParam)
)
​