Report Subscriptions

Hello,

I have a dril lthrough report which takes a long time (5-7 minutes) to fetch the results. The reason is that the data it returns is huge as it fetches sales data till the lowest level.

when the users later on trz to export it to excel it takes again a lot of time and eventuallz the szstem freezes. I think the volume of export might be in the range of 14/15 MB.

Is there a way to reduce first the execution speed of the report and then secondly reduce the time to export the report?

Or a way where the report is executed once a day and everyone shares the already published report?

regards

Josh

Hello Josh,

Yes, you can cache your report once a day and have everyone share it.

Open Report Manager (http://ServerName/Reports) and drill down to your report. Click on the Properties tab across the top, then click Data Sources from the left pane. Check the box for 'Credentials stored securely in the report server' and enter a valid user/password to run the report. If your account is a domain account, check the box for 'Use as Windows credentials when connecting to the data source', then hit Apply. Now, click on the Execution link from the left pane. Select 'Render this report from a report execution snapshot', configure your schedule to run once daily at whatever time you wish, then hit Apply.

By doing this, whenever a user goes to view this report, they will see the cached version of the report and they won't have to wait for the report to be generated.

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks!

regards

Josh