Post reply

Subscription in SSRS - Can perform two tasks?

  • June 5, 2008 at 11:48 am

    #191754

    I want to create the Subscription / data driven subscription in SSRS which sends and email to the recipients

    and also exports to the shared location. I don't want to create the two subscription for each task.

    Is it possible?

    Thanks.

    Gunjan.

  • June 13, 2008 at 7:24 am

    #828464

    Hi Gunjan,

    See...you want to create subscription / data driven subscription and you wish to send e-mails..this you can acheive with a receipients list which you can either create directly on Sql Server database or you can even provide a UI so that it can be created by the client itself...

    Now...It will send the e-mails as well as export the desired reports according to the Export Options you have mentioned in the Table..[as a field...]

    If this was the issue....then it is possible...easily you can do this using ReportService2005 methods...

    If I have misunderstood your issue...then pls let me know..with a brief explanation so that [if possible]..I may help you..:)

    Regds,

    Niraj

  • June 13, 2008 at 7:34 am

    #828477

    Hi Niraj

    Thanks for the reply.

    Ya I do have the fields in the table for email and export options like To,CC,BCC,Subject for email and shared location path , userid, password etc. for export.

    As email subscription sends the report as a pdf (.pdf which is my requirement) in attachment now can we store the same report on any shared location like what the export subscription is doing? So instead of creating two subscription (one for email and one for window share) I can create the one.

    Is it possible?

    Thanks...

    Thanks.

    Gunjan.

  • June 13, 2008 at 7:41 am

    #828489

    My pleasure..Gunjan..

    Well I understood your requirement...

    Okay...just give me few mins...[Let me try the same; first on my end...]...

    Thanks,

    Niraj

  • June 13, 2008 at 7:56 am

    #828511

    Gunjan,

    We can use ExtensionSettings.Extension Property which carries the extension property for any subscription we create, right!

    So..we will be creating an object for WebReference.ExtensionSettings and using that object we can specify what we wish to use....

    ..I think...with a small change in code...where you have mentioned "Report Server E-mail"...we can use

    "Report Server FileShare" for Windows File Share....But...it seems that we can use either Windows File Share or E-mail...at a time...neways..I will also try this...If you get any solution...then please let me know..also...

    I hope...it may help...(somewhat)...

    Regds,

    Niraj

  • June 13, 2008 at 8:01 am

    #828518

    Hi Niraj,

    That's what I am trying. Anywayz I will let you know if I will get any solution...

    Thanks.

    Thanks.

    Gunjan.

  • June 19, 2008 at 6:37 pm

    #831461

    Good morning guys,

    I found this document which explains things very well;

    http://msdn.microsoft.com/en-us/library/aa237461(SQL.80).aspx

    This copes with multiple recipients, different formats, different priorities etc etc.

    Hope this helps 🙂

    - Damien

Viewing 7 posts - 1 through 6 (of 6 total)

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