Post reply

Multiple Data in Report Parameter in Subscription

  • August 15, 2016 at 7:07 pm

    #400578

    I have a report that needs a report parameter loaded being a campaignID as follows:

    where GC.[CampaignID] like (@CampaignNo)

    Sometimes the person running the reports wants to have several reports emailed to the same email address as a subscription. I have no issue with sending each report separately however is there a way to load one or more CampaignIDs in the same parameter box?

    i only know how to do basic reporting so looking for a simple solution if there is one. 😀

  • August 16, 2016 at 7:25 am

    #1895638

    In SSRS, make sure your parameter allows multiple values by going to its properties and ticking "Allow multiple values". When you preview the report, type one value per line if it's freetext, or just tick the box next to the values if you're used a predetermined list of available values. Make sure your WHERE clause does read 'IN(@Parameter)'.

    Once this change is uploaded to your report server, in the subscription settings you will then be able to enter multiple values in the same way - one value per line.

    Note that this will send a single report rather than several reports, so you may need to amend your grouping and sorting accordingly.

    Let me know if that doesn't work/you need to know more 🙂

    LinkedIn

  • August 16, 2016 at 8:02 pm

    #1895820

    TinDog, Many thanks but I was actually looking for a way to send several reports to the same email and not having 1 report with several campaigns.

  • August 17, 2016 at 2:54 am

    #1895859

    I see. I can't think of any straightforward way to do so without creating yourself too much work.

    LinkedIn

  • August 17, 2016 at 5:07 pm

    #1896066

    Thanks anyway.

    Les

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

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