Generate two outputs on a single Subscription

[djpirra]

Hi everyone,

I have a scenario where I am dealing with too many data-driven subscriptions being required in order to generate EXCEL and PDF files on a repository.

According to the current configuration the report needs to execute twice for the same parameters in order to generate one EXCEL and one PDF.

My question is if there is a way to reduce the number of report executions per subscription taking advantage of the data being already in cache and just generate the two outputs EXCEL e PDF in one go.

Thank you

Regards,

LS

[DavisBI]

Hi, @djpirra ,

Your idea is great, but it requires modifying the system stored procedure of the report server database. If you're not clear about the logic here, it's not recommended, but you can create a copy on your local machine and do this test.

Best.

[djpirra]

Hi DavisBI,

What stored procedure is that? Can you provide more details on what could be tweaked in order to support such scenario?

Regards,

LS