Forum Discussion

djpirra's avatar
djpirra
Helper III
5 years ago

Generate two outputs on a single Subscription

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

Help Requested
Power BI Report Server
reporting services
SSRS 2017

2 Replies

  • DavisBI's avatar
    DavisBI
    Solution Specialist
    5 years ago

    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's avatar
      djpirra
      Helper III
      5 years ago

      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