0

I am using Data driven subscription to send report in Email body and as an excel attachment.

enter image description here

In email,I am seeing the report as Body,but report as excel attachment is missing.

The requirement is I need report to be send as an attachment and in Body in one email.How can I achieve this using Data driven subscription.

I have created table with two rows and format like 'excel' and 'mhtml' and referring the column 'REPORTFORMAT' to Render format.

Please let me know how can i send both in one email

AMDI
  • 895
  • 2
  • 17
  • 40
  • can you show what your "REPORTFORMAT" column value is? I have my doubts on rendering both excel and MHTML in a single subscription. – Harry Mar 16 '20 at 20:13
  • @Harry- I am having two rows for subscription dataset with "REPORTFORMAT" column value as "excel" in one row and second row as "mhtml". – AMDI Mar 16 '20 at 20:25
  • each row of data will turn into a separate run of the subscription.. that is how Data Driven subscription works. See answer below from Hannover – Harry Mar 16 '20 at 21:48

2 Answers2

2

You cannot do it automatically - Include Report determines whether the report is included as either an embedded report or attachment but cannot do both.

Include Report: Select this option to embed or attach a copy of the report. The format of the report is determined by the rendering format you select.

MS Docs: Create Subscription

You current process with two rows should be creating two reports - one with an attachment and one with it embedded.

You could add the data in the report body in the Comment field but the data would need to be converted in to an HTML table.

Hannover Fist
  • 10,393
  • 1
  • 18
  • 39
0

You need to use the string "EXCELOPENXML" as the rendering format, then it will work. It used to work with the string "Excel" only but now it no longer works like that. With Word you also need to use the string "WORDOPENXML". You will then get the reports as attachment files, as per your requirement.

Charles

Charles Kangai
  • 13
  • 3