Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2008-04-04 : 00:14:50
|
| Hi, I have two input parameters one is text control and second oneis multiselect list box in one of my reports. MultiLIst box will be always populated with the search results from text control value. When we modify value in text box every time it is fetching results from data base where it is taking so much time. Total number of values that are getting fetched are atmost 4k. Please can you tell me a way when I hit first time these values fetched from database and keep them in client cache. Next time when I search for some data it wont call database just it fetches from cache.ThanksDasu.G |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-04 : 12:01:55
|
| Are you taking about caching of parameters? There is a property in report manager which enables caching on the report. Once set, it will cache report data once its rendered for first time. |
 |
|
|
|
|
|
How to cache SSRS input paramters