Hi all,
Does anybody know how to set the parameter's default value dynamically?
I'm working on a report with some parameters against datacube, and I hope the default value of one of the parameters could be set dynamically based on the user's login.
Thanks,
Jone
Jone,
In your Report Parameter - Default Values - Non-Queries you can place an expression like so:
=IIf(User!UserID = "Bob", "USA","Canada")
I hope this is what you were looking for.
Ham
