Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

SSRS preview report refreshing

i have a SSRS report. when i preview the report it takes a few minutes to generate the preview. is there a way to cache the report so when i preview it instantly displays the results and reflect the formatting changes that i apply like crystal does.

Thanks
0
raufraza
Asked:
raufraza
1 Solution
 
raufrazaAuthor Commented:
i have tried this and it works as far as report builder is concerned but i am developing in visual studio. is there any any way to replicate it on VS?
0
 
TempDBACommented:
Another option is you can build a cache table for yourself. You must be doing some calculations which involves different tables to build your dataset. Just schedule with the help of some job and create a table where you fill up all the possible results. So, finally for getting your dataset, you will do a select columnNames from YourTable.
0
 
Alpesh PatelAssistant ConsultantCommented:
in development environment it is not possible.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now