Auto RUN a BIDS Report ....?

Posted on 2008-06-26
Medium Priority
Last Modified: 2013-11-05

Is it possible to have a BIDS report run / PROCESS automatically, then SAVE the data so that when a USER opens the BIDS report..that the data is already populated in the report?

Or does BIDS always have to process the data at the time a report is opened by the USER?

Question by:MIKE
LVL 13

Accepted Solution

rickchild earned 2000 total points
ID: 21877567
There are a couple of solutions.  You can set a report to cache and use that data for a period of time, or you an set the report to run to a schedule, and then the user will see the data from that snapshot.

You can configure this once the report is deployed on the server by usin Report Manager.


Go to the properties of a report, and then execution.
From here you will see the caching option (Cache a temporary copy of the report) and the snapshot option (Render this report from a report execution snapshot )

See here for more info:   http://msdn.microsoft.com/en-us/library/ms178821(SQL.100).aspx
LVL 17

Author Comment

ID: 21877597

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question