Post reply

Report Not Pulling Changes From Stored Proc

  • June 11, 2014 at 12:31 pm

    #1720870

    Go to the folder where the report is stored. There is probably a cached data file with the extension .DATA. Delete that file and try again.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 11, 2014 at 12:51 pm

    #1720878

    Thank you, Koen, that worked. However, isn't there a more efficient way to handle incorporating query revisions into the report?

  • June 11, 2014 at 2:10 pm

    #1720894

    fstop (6/11/2014)

    Thank you, Koen, that worked. However, isn't there a more efficient way to handle incorporating query revisions into the report?

    Not really (although someone made a shortcut: Clear Report Data Caches from Within BIDS). It may seem like a drag, but imagine life without SSRS caching the data. Suppose your stored proc runs for 30 seconds. Each time you want to view the report while designing it, you'd have to wait 30 seconds.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply