Report Title in Report manager Subscription

[SQUASHJUNKIE]

Hi,


Is there a way of passing a default parameter value into the subject title on a report subscription?

Currently there are std global variables i.e. @ReportName was executed at @ExecutionTime, but what other variables can be passed here to make it more relevant to the recipient?


Thx

 

[SQLBI]

I've not tested this as i've not got a mail server set up but i would imagine you can reference both the Globals and Parameters collections in the subscription email title. As with the examples given, make sure you prefix each name with the @ sign.

Take a look at the available Globals and parameters from the Expression editor and test your subscription.

Hope this helps.

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[SQUASHJUNKIE]

yep...already tried that...didn't work.
Tried using @[parametername] and the full name i.e.
@parameter![parametername].value
without any success.