When setting up the parameters for a report, it's possible to specify a default value for the first time a user runs that report, but there's no obvious way to determine a default dynamically. Has anybody found a way to do this? It's easy if you use the native SSRS parameter features, but I would like to be able to do it with the Tessitura report setup tools.
Interesting — can you give an example of what this might look like? Curious as to what the dynamic value would be based on. User ID? getdate()? Stock price?
Given how default report parameter values are only ever explicitly referenced a maximum of one time per user, I might instead be looking at some way to embed that dynamic logic into the SSRS or SQL layer, and surface it to the user through another parameter. Like:
- P1: Use dynamic value for P2? (Y/N)- P2: Manual value (Disable when P1='Y')