none
SSRS subscription

    Question

  • I am using SSRS subscription to notify once the files are dropped to the given location to certain team members.

    In the body of the email I am using HTML due to spacing issues caused in merely writing it (line breaks can be easily done in HTML) :

    <html>
    <body>
    <p>All Files have been dropped : </br>
    Client 1 - ABC_@Getdate.xls  </br>

    Client 2 - DEF_@Getdate.xls

    </p>
    </body>
    </html>

    I want to incorporate today's date in this HTML, so the file name should be 20131011.xls

    The files are being dropped with today's date in a given folder, so I want to notify the recipients of the file dropped with it's file name.

    Any ideas on how this can be achieved? 

    Friday, October 11, 2013 8:57 PM

Answers

All replies