Data Driven Subscription Workaround

Question

Data Driven Subscription Workaround

tindog

SSCarpal Tunnel

Points: 4892
More actions
August 28, 2016 at 11:07 pm

#329689

Comments posted to this topic are about the item Data Driven Subscription Workaround
LinkedIn

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

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

John N Hick Ten Centuries Points: 1320 More actions · Answer 1

Thanks for sharing! We did a similar workaround, except we created a configuration DB and normalized it, due to the complexity of our systems.

janspath SSC Enthusiast Points: 105 More actions · Answer 2

How is the performance with your solution compared with the enterprise SSRS rendering? I tried a clumsy solution of calling each report individually but the performance was way too slow. With the enterprise SSRS, I can render 1500 PDF files and store on a file server in 15 minutes. My solution was taking way over one hour.

We have an older version of the Enterprise SSRS just for this report. Would love to ditch it and use the 2016 version for all of our reporting.

Thanks.

philcart SSC-Forever Points: 47796 More actions · Answer 3

Interesting solution. Just proves the point that there are always many different ways to achieve the same result.

We solved this issue with a very basic C# console app which called a stored proc to obtain the report parameters and then generate PDF's using the web service. Not sure about timing, but it was way quick enough for our needs.

--------------------
Colt 45 - the original point and click interface