From: Mike on
I would like to be able to dynamically change the Prompt and Hidden
Properties of a report parameter based on another parameter.

Ideally, I would like to be able to do this within Reporting Services, but
if this is not possible I could perform a solution outside reporting services
to manually change the report before the report is rendered.

I've looked online and haven't been able to find solutions.

Any help would be greatly appreciated.