<div>
Hi,<br />
<br />
&nbsp; this is possible in ssrs &nbsp;. refer the below<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms155927.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms155927.aspx</a><br />
<a href="http://www.mssqltips.com/sqlservertip/1919/how-to-enable-caching-in-sql-server-reporting-services-ssrs/" rel="ugc">http://www.mssqltips.com/sqlservertip/1919/how-to-enable-caching-in-sql-server-reporting-services-ssrs/</a>
</div>


Hi,

  this is possible in ssrs  . refer the below

http://msdn.microsoft.com/en-us/library/ms155927.aspx [http://msdn.microsoft.com/en-us/library/ms155927.aspx]
http://www.mssqltips.com/sqlservertip/1919/how-to-enable-caching-in-sql-server-reporting-services-ssrs/ [http://www.mssqltips.com/sqlservertip/1919/how-to-enable-caching-in-sql-server-reporting-services-ssrs/]

<div>
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?
</div>


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?

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Thanks
</div>
</div>


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

SSRS preview report refreshing

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.