• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Auto RUN a BIDS Report ....?

Experts:

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?

thanks
M
0
MIKE
Asked:
MIKE
1 Solution
 
rickchildCommented:
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.

http://YourServerName/Reports

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
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
Thanks....
0
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

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now