Friends,
Microsoft provided data caching option which is a real great boon to the developers and few times the real curse too. Let me explain both the cases here.
Let’s say we have written a query which returns 1 million records from database and using the same output a SSRS report is designed. As you all know it takes minutes to get 1 million records from database and more time to display the same in SSRS report. The data is tested and it is perfectly working and not the work is on Look and Feel of the report like setting colors, fonts and more. When ever you make any change to the Format of the report then you have to see the preview of the report. Here comes the advantage of having data cache in SSRS designer. When ever I click on preview after making changes then the SSRS will uses the data cache option and displays the caches data with new format instead of hitting the database to fetch the data fresh. This helps us in saving our time while development. If this data cache option is not available then for every change the query will be hit and the data will be fetched from database. This will not have much impact if the query is fetching less data but when the data is huge then it is gonna kill the time during development. So, in simple when the report dataset is fetching huge data then better to have data cache enabled to save time during development.
Now, let’s see the disadvantages of having data cache enabled. If the data is changed in your database and you want to see it then this data cache should be disabled else it will pull and show the same old cached data again and again. Let me explain a scenario which killed my time. I was new to SSRS and when i was working on PROTOTYPE, I designed a report on DUMMY data and everything was working fine. When I have given demo to my manager he asked me to add more records before we give demo to user. I added more data and everything was set. When the demo to users started, we were surprised by seeing the same old junk data in report(including my name and my gf’s name .. :p). As I was not aware of this option it ruined my day. After long search in google I cam eotknow about this option.
So, it is very important to be aware of this option. This can be Enabled/Disabled in the file present in the below given folder.
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
In that file you can see an option “CacheDataForPreview” and you have to turn this off/on to disable/enable this feature. PFB the screenshot showing the same.
This is a simple feature but very useful one to developer. So, it is very useful to keep an eye on this while developing SSRS reports.
That’s it .. Hope you understood.
Regards,
Roopesh Babu V
gay teen chat
[url=”https://chatcongays.com”]gay chat room in my area[/url]
gay chat site
service essay writing
[url=”https://au-bestessays.org”]essay editing services[/url]
essay writer software
community service essays
[url=”https://bestcampusessays.com”]what are good essay writing services[/url]
help essays
need help to write an essay
[url=”https://besteasyessays.org”]best essay writing service[/url]
help writing college essays
tok essay help
[url=”https://bestessayreviews.net”]editing essay services[/url]
essay online help
college admissions essay help
[url=”https://bestessaysden.com”]order cheap essay online[/url]
cheap write my essay
medical school essay writing service
[url=”https://bestsessays.org”]write my essay generator[/url]
us essay writing service
help essay 123
[url=”https://buyacademicessay.com”]buy custom essay online[/url]
buy essays for college
usa essay writing services
[url=”https://customcollegeessays.net”]essay writer cheap[/url]
essay help introduction
essay writers
[url=”https://customessays-writing.org”]college admission essay service[/url]
best college essay editing service
help writing a comparison and contrast essay
[url=”https://firstessayservice.net”]hire someone to write my essay[/url]
can somebody write my essay
essay writers net
[url=”https://geniusessaywriters.net”]help writing my college essay[/url]
essay writer website
buy essays online
[url=”https://lawessayhelpinlondon.com”]buy an essay paper[/url]
buy essay papers online
best essay writer service
[url=”https://ukessayservice.net”]essays writing service[/url]
professional essay writing service
essay marking service
[url=”https://au-bestessays.org”]the help essay[/url]
best writing service reviews
custom coursework writing service
[url=”https://brainycoursework.com”]coursework moderation[/url]
coursework research
https://drugsoverthecounter.shop/# epinephrine over the counter
[url=https://over-the-counter-drug.com/#]over the counter pain medication[/url] united healthcare over the counter essentials
ciprofloxacin increases effects of saxagliptin by pharmacodynamic synergism 5 mg cialis generic india Epub 1992 03 29
over the counter weight loss pills over the counter inhaler
[url=https://over-the-counter-drug.com/#]best ed pills over the counter[/url] nystatin cream over the counter