Hi Namnami, You can use the concept of caching in reports like you said snapshot; but still at first go it would take original time to execute and then will show data at once but fraction of seconds. All in all; you can use Caching concept in report and call them in your website.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi, My company wants to display some of the SSRS reports in the company's web site - not a sharepoint site. They would like the reports to be displayed immediately without waiting runtime. I thought of giving them the link for the reports and setting the reports to run from snapshot. ThanksNamnami

Hi Namnami, You can use the concept of caching in reports like you said snapshot; but still at first go it would take original time to execute and then will show data at once but fraction of seconds. All in all; you can use Caching concept in report and call them in your website.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/