INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Delay delivery of report?

Delay delivery of report?

(OP)
Hi all

I have been doing a bit of searching to no avail. I have a report set up that takes a snapshot at a point in time. The time I need the snapshot is 23:59. This report then needs to be emailed to a distribution list.

My objective is to delay the delivery of this report until 7am the following morning. At the moment I have it set to download to a network location and then a separate script to email it on.

For a couple of reasons I want to tidy this up but I wonder does anyone know whether it is possible to do as I have outlined.

Thanks for your time.

pentesh.

RE: Delay delivery of report?

There is no way to do this within BusinessObjects itself. Your solution of exporting to file and then emailing that file via a script outside of BO is the only way to accomplish this using your current process.

Another possible way you could go about this would be to schedule a stored proc in the database to run the report's query at 23:59 and save the data to another "reporting" table. You would then have the report run against that saved data at the time that you want to deliver the report.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Delay delivery of report?

(OP)
Thanks for that. Suspected that may be the case.

Thanks again for the reply.

pentesh.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close