locked
Why does SSRS not create a .rdl.DATA file when previewing a report? RRS feed

  • Question

  • 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

    Monday, June 27, 2011 4:07 PM

Answers

  • 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.

    • Marked as answer by Challen Fu Thursday, July 7, 2011 9:32 AM
    Tuesday, June 28, 2011 7:11 AM

All replies

  • 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.

    • Marked as answer by Challen Fu Thursday, July 7, 2011 9:32 AM
    Tuesday, June 28, 2011 7:11 AM
  • Hi Challen,

    On my machine CacheDataforPreview is already set to True. Yet no .DATA files are created within a BIDS development project, and also like awright18 has reported the entire report seems to be recalculated after making even a minor layout change and clicking Preview within BIDS.

    Any ideas?

    Thanks

    Just to add: This is 2008 R2. Never had the problem when I worked on 2008.
    Tuesday, August 16, 2011 9:46 AM
  • Please install the SP1 for SSRS 2008 R2, then you will have the rdl.data file. SP1 is available at this link http://www.microsoft.com/download/en/details.aspx?id=26727

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Proposed as answer by Theroyale Wednesday, August 17, 2011 1:40 PM
    Wednesday, August 17, 2011 1:39 AM
  • Thanks. Do I need to install SP1 on the server or just on my local machine for this change to apply?

     

     

    Wednesday, August 17, 2011 8:57 AM
  • If you want to get this rdl.data file in local develop environment, just install it in local machine.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, August 17, 2011 9:24 AM
  • Thanks!
    Wednesday, August 17, 2011 1:40 PM
  • Thanks Challen,

    This Help me alot.  

    Thanks

    Neeraj


    • Edited by NeerajSQL Friday, January 17, 2014 10:00 AM
    Friday, January 17, 2014 9:59 AM