Post reply

Is there a way to email a PDF version of rpt and render an HTML version in email body

  • August 8, 2017 at 11:17 am

    #402403

    Hi All,

    I've been searched online to see if anyone has come up with a creative way to send a single mail with a SSRS report rendered 2 different ways. Example: send a PDF attachment, but also render SSRS report results in the body of email as HTML. I know you can set up 2 subscriptions, but I'm trying to avoid that approach. Any feedback is greatly appreciated.

    Thank you,
    Cervello

  • August 8, 2017 at 11:52 am

    #1954519

    Hi,
    The way I achieved this was
    Two subscriptions. One which places an excel version of the report onto a network share and the other which places a html version of the report onto a network share.
    An SSIS package which runs a script task which picks up both files - creates an attachment of the excel file and puts the html into the body of the email.
    This script task then sends the email.
    It works well. Downside is there are 3 subscriiptions/jobs which need to be managed.

  • August 10, 2017 at 5:44 am

    #1954771

    Thank you for the feedback. I have not used SSIS

    but will reach that option further. I appreciate the help!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply