Post reply

Sending a report to multiple people(People are choosen dynamically)

  • January 26, 2010 at 10:49 am

    #219974

    I have billing report which I want to send it to our customers.I know how to set the email address dynamically.But what I dont know is the way to filter the data for each client.I mean each client receive its own billing information.Is there a way to implement this in Reporting Service 2008.

    Thanks

  • January 26, 2010 at 8:51 pm

    #1109036

    I think Datadriven subscription will help you.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • February 14, 2010 at 11:04 pm

    #1118664

    Yes, you can do this using Data Driven Subscriptions. I have done exactly this same thing. Pass the customer as a report parameter. Create a Data Driven Subscription, and pass the customers from the database to the report parameter. It will invoke the report once for each customer value passed to it.

    Email me if you have any questions.

    David Richardson

    Public-Sector Solutions

  • February 16, 2010 at 12:50 am

    #1119092

    Hi Guys,

    I'm interested in this solution as well, can you share your knowledge on this please.

    Regards,

    Sun

  • February 16, 2010 at 1:53 am

    #1119110

    sun_kuang (2/16/2010)

    Hi Guys,

    I'm interested in this solution as well, can you share your knowledge on this please.

    Regards,

    Sun

    Data Driven subscriptions are an enterprise edition feature, so if you cant find the option that'll be why.

    You could try to modify my code Here for another possible solution


    Clear Sky SQL
    My Blog[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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