Dynamic fields on a Sales Order Summary Report Email Settings
Can I use dynamic fields in the reports' email settings? I would like to pull the date field automatically instead of having to enter it every time I send the report by email.
Does leaving the dates blank as suggested in this post work?
@timrodman the issue is not with the scheduling itself, but rather with inserting a dynamic date field on the email subject so that when the schedule triggers the email, the recipient can see the date on the email subject.
Ah, I see. I haven't tried this, but maybe you can leave Subject empty on the screen and modify the Subject in the report definition?
Sorry, by "Subject in the report definition", I meant in Report Designer, not when you run the report on the screen.
If you open the report in Report Designer, you can go to the report properties and populate a formula in the MailSettings -> Subject field like this:
When you do that, then run the report in the screen and press the SEND button, you should see that the formula works:
I'm not sure though if scheduling a report will respect the formula. I'd love to hear if it works for you in a schedule.