Post reply

E-Mail Delivery in SSRS

  • June 5, 2012 at 8:25 am

    #261963

    Hi All,

    E-Mail Delivery in SSRS, is it possible?

    I have a SSRS Report and i will schedule SSRS Reports daily at 6:00 PM

    What i need is: i need a way to e-mail a message to individual users or groups that the daily schedule report is ready please go and check the report in portal.

    In the mail i don't want to send the report, i just want to send a message to the users that go and check the report in portal.

    Please let me know how to do this? Thank you

  • June 5, 2012 at 8:29 am

    #1497082

    In a report subscription you can "Include report" or "include link" or both. In your case I would just include the link.

  • June 5, 2012 at 8:36 am

    #1497086

    Daniel Bowlin (6/5/2012)

    In a report subscription you can "Include report" or "include link" or both. In your case I would just include the link.

    I don't want to include the report in send mail task

    so, as you are saying we can include link in that mail

    can you please let me know the process how to do this?

    but mainly what my idea is i need just a message to be send in mail, if this is not possible i will try to do with including link. Thanks

  • June 5, 2012 at 12:28 pm

    #1497260

    I tried some thing and finally i am at this stage

    After Subscription it asks

    choose "e-mail" as your delivered by option

    Now i unchecked the check box that says "include report" and "include link"

    I don't want to include report and also link in it....I just want to send a message that report is ready, go to portal and view the report.

    For this what process do i need to do now. Help me out plz!!

  • June 6, 2012 at 10:07 am

    #1497731

    I guess I don't understand the issue of providing a link to the report. This just makes it easier for the user to get to the report on the portal.

    I am also curious what it is that makes your report "ready." Are you caching the report and only updating at certain times of the day? If you have some background process (i.e. SQL Agent job) to build data for the report, you could probably make the email delivery the last step of that process. This way you are not stuck with the report subscription options.

  • June 6, 2012 at 10:23 am

    #1497740

    Daniel Bowlin (6/6/2012)

    I guess I don't understand the issue of providing a link to the report. This just makes it easier for the user to get to the report on the portal.

    I am also curious what it is that makes your report "ready." Are you caching the report and only updating at certain times of the day? If you have some background process (i.e. SQL Agent job) to build data for the report, you could probably make the email delivery the last step of that process. This way you are not stuck with the report subscription options.

    Why i don't want to add report or URL link is because every one has to go to portal to view the report.

    "Ready" is nothing i just want to send some bla bla bla message in it, that's it. Ready is not the exact term. sorry!!

  • June 6, 2012 at 11:26 am

    #1497782

    And the URL link will bring them to the portal, I don't see the problem, this way is fewer clicks for the end user.

  • June 6, 2012 at 12:25 pm

    #1497835

    Daniel Bowlin (6/6/2012)

    And the URL link will bring them to the portal, I don't see the problem, this way is fewer clicks for the end user.

    OK, i will try this first. If i get any problem will get back to you. Thank you

  • June 7, 2012 at 2:11 pm

    #1498407

    Thanks all,

    I got this with out attaching Report and URL link i can send mail to group of people.

    Now, the other thing is how to take snap shot for reports and where the snap shots will store?

Viewing 9 posts - 1 through 8 (of 8 total)

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