Why does SSRS not create a .rdl.DATA file when previewing a report?
We have been using SSRS 2008 for several weeks generally connecting to an Oracle database and returning large amounts of data in our reports. The common issue we are seeing is that when switching from preview to design and vice versa after only making layout changes the data is not cached, when switching back to preview. Also there are not and rdl.DATA files being generated. Is there is a switch anywhere in BIDS to turn this on and off or some other reason why the data wouldn't be cached? A size limit perhaps? -Adam
June 27th, 2011 7:07pm

Hi Adam, Actually, BIDS uses a data cache when designing reports to speed up your development and improve design-peview-design-preview iterations. So if you don’t want to keep this feature, of course you can turn it off, steps are below: Find your config file that controls the Report Designer in BIDS. For SQL Server 2008 SSRS, this should be: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config Change CacheDataForPreview to “false” , if you want to turn it on, just change CacheDataForPreview to “True” Thanks, Challen Fu Forum Support If you have feedback for TechNet Subscriber Support, please contact us Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 10:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics