October 12, 2017 at 3:31 pm
My goal is to have 2 separate SSRS 2008 R2 reports instead of combing them into one report. There is an existing SSRS 2008 r2 report that is extremely complex and I do not want to add another tablix with a unique dataset to this existing rdl.
Due to this fact, the user said I can create 2 separate reports only if a data driven subscritpion can be setup where all the links and/or data is in one email message. My company is in the process of setting up a report server 2016 that will be used in production in the near future.
Thus can you tell me if a data driven subscription on a report server 2016, can run 2 separate reports and send out the data for both reports in one email message? If this is possible, can you tell me how to acomplish this goal and/or point me to links (urls) that will tell me how to accomplish this goal? If this is not possible, would you let me know that also?
October 13, 2017 at 10:04 am
wendy elizabeth - Thursday, October 12, 2017 3:31 PMMy goal is to have 2 separate SSRS 2008 R2 reports instead of combing them into one report. There is an existing SSRS 2008 r2 report that is extremely complex and I do not want to add another tablix with a unique dataset to this existing rdl.
Due to this fact, the user said I can create 2 separate reports only if a data driven subscritpion can be setup where all the links and/or data is in one email message. My company is in the process of setting up a report server 2016 that will be used in production in the near future.
Thus can you tell me if a data driven subscription on a report server 2016, can run 2 separate reports and send out the data for both reports in one email message? If this is possible, can you tell me how to acomplish this goal and/or point me to links (urls) that will tell me how to accomplish this goal? If this is not possible, would you let me know that also?
I'm not 100% sure, but I'm not aware of SSRS being capable of that with data driven subscriptions. It would specifically have to have been programmed to do such a thing, and I can't really at that point see a reason NOT to then program in the ability to add any number of reports to the subscription, save the performance implications of running some arbitrarily large number of them. The amount of effort MS would have had to expend to do that would have been sizable, so I'm very doubtful that this ability exists. If you look into creating a data driven subscription, and you don't see an option for it, then you can be pretty sure it doesn't exist.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 13, 2017 at 10:35 am
sgmunson - Friday, October 13, 2017 10:04 AMI'm not 100% sure, but I'm not aware of SSRS being capable of that with data driven subscriptions. It would specifically have to have been programmed to do such a thing, and I can't really at that point see a reason NOT to then program in the ability to add any number of reports to the subscription, save the performance implications of running some arbitrarily large number of them. The amount of effort MS would have had to expend to do that would have been sizable, so I'm very doubtful that this ability exists. If you look into creating a data driven subscription, and you don't see an option for it, then you can be pretty sure it doesn't exist.
I'm pretty sure it doesn't either and I've seen some talk about this before.
One of the workarounds I've seen is to have the reports go to a file share (instead of emailing directly) and then have SSIS pick up and email those two reports as attachments. Can't remember all the details to set it up but that was the gist of it.
Sue
October 20, 2017 at 8:49 am
Yeah, this is not possible from what I know. I believe Sue_H's suggestion above is the best way to go. I use subscriptions that write to a file share, they're are not difficult to set up. Using SSIS (or some other alternative) to watch a directory and gather files matching a certain naming convention and sending and email with both as attachments is not quite as easy but it's doable, for sure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply