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.
Default, yes. Set it in report setup in the "default value " field. Dynamic, no. You could do some testing I guess when it is run in the stored procedure when nulls are passed for the dynamic idea.