Multiple Data in Report Parameter in Subscription

  • 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. 😀

  • 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 🙂

  • 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.

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

  • 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