Wednesday, March 7, 2012

Possible to cache a dataset when testing in Visual Studio?

I do a lot of work with a report that calls a stored procedure that takes
about 2 minutes to complete. It annoys me that when I change one little
formatting property in the layout, I have to wait for the stored procedure to
run again before I can see the results of my modification. I wish that I
could just cache the dataset created by this stored procedure when I'm
testing in Visual Studio and avoid rerunning it each time I change the
formatting. Can anyone tell me if this is possible? Thanks.It sounds like you did not install SP1 on your report designer machine. See
this section of the SP1 readme:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_report_designer_preview
SP1 can be downloaded here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan Wrobel" <StefanWrobel@.discussions.microsoft.com> wrote in message
news:FD067DE7-1DD1-463F-90E1-F835206D966C@.microsoft.com...
>I do a lot of work with a report that calls a stored procedure that takes
> about 2 minutes to complete. It annoys me that when I change one little
> formatting property in the layout, I have to wait for the stored procedure
> to
> run again before I can see the results of my modification. I wish that I
> could just cache the dataset created by this stored procedure when I'm
> testing in Visual Studio and avoid rerunning it each time I change the
> formatting. Can anyone tell me if this is possible? Thanks.

No comments:

Post a Comment