topic Variable Month in E-Mail Subject and Text in Reporting Service & Alerting

Variable Month in E-Mail Subject and Text

olenedderhoff — Fri, 15 Nov 2024 20:56:34 GMT

I am sending out a weekly Report via the Reporting Service and want to include the current month inside of the title and text of the Mail. Is there any automated way of doing this like:

Bonus Report <Month>?

Re: Variable Month in E-Mail Subject and Text

F_B — Fri, 25 Oct 2024 06:56:50 GMT

Hi @olenedderhoff ,

are you sending reports using Subscription, Tabular Reporting or Appllication Automation?

Re: Variable Month in E-Mail Subject and Text

olenedderhoff — Fri, 25 Oct 2024 08:51:29 GMT

I am using tabular reporting via the Excel Add-In and create the Report in the Reporting Section of my App.

Re: Variable Month in E-Mail Subject and Text

diegozecchini — Fri, 25 Oct 2024 11:27:56 GMT

Hi!
You can create a variable, e.g., vCurrentMonth, and set its expression to display the current month dynamically. You can use Date(Today(), 'MMMM') to get the current month in full name (e.g., "October").

Then when configuring the email subject or body in your Reporting Section, you can reference the variable you created:

In the subject line of the report, include $(vCurrentMonth) where you want the month to appear. For example:

Bonus Report $(vCurrentMonth)
This will automatically replace $(vCurrentMonth) with the current month name in both the subject line and body of the email when the report is sent.

Run a test to ensure that $(vCurrentMonth) correctly resolves to the current month. This should now automatically update every time the report is generated.

Re: Variable Month in E-Mail Subject and Text

olenedderhoff — Fri, 25 Oct 2024 11:44:06 GMT

With these Setups:

let vCurrentMonth = Date(Today(), 'MMMM');

I unfortunately get this result in the Mail:

So this approach does not work.

Re: Variable Month in E-Mail Subject and Text

Lech_Miszkiewicz — Fri, 01 Nov 2024 09:18:06 GMT

Hi @olenedderhoff

There is no way to currently get variables into email subject and text when using Tabular Reporting solution for now.

Sorry

cheers