Data snapshot for use during development?

Last Post 05 May 2004 06:27 AM by SQL Pro. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bpc0n335
New Member
New Member

--
04 May 2004 01:16 PM
I'm developing a report which runs several queries and takes half an hour to complete. Is there a Report Designer option I can set to retain the data from one set of query executions, so that I can change the report layout without having to wait for the datasets to be refreshed each time?

Seems like a simple thing, but I wasn't able to find anything on it in RS-BOL...

Thanks,
Bob Christensen
SQL Pro
New Member
New Member

--
05 May 2004 06:27 AM
I don't think there's anything in Design mode to help you out there. I think you'll need to take some other approach.

Try putting TOP 1000 or something in your query, you shouldn't need all the data for design.
Or add some indexes to the tables to speed up the query
Or make a table of the results that you only update when needed
dmcdowell
New Member
New Member

--
17 May 2004 10:22 AM
This functionality may be made available in Reporting Services SP1 due out this summer.
You are not authorized to post a reply.

Acceptable Use Policy