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

Schedule a report without parameters?

Schedule a report without parameters?

(OP)
We want to schedule a report with 2 parameters but at schedule time we would not know what they were. The idea is to have the report contain all data needed for any case, then open it with the parameters and have it return just the data for those without requerying the db. It is a tremendously long-running report even with the parameters if it is hitting the db. Is this even possible?

RE: Schedule a report without parameters?

You could create report 2 (by modifying a copy of existing report 1)that creates a table with all the data, e.g. Stock levels as at "date/time".
The table saves to Excel for example. If very large, it can save to Excel then link an access table to it.
This is in effect a 'view'. Schedule it to run every x mins, allowing time for it to save before the next scheduled run.

Then create report 3,(by modifying a copy of existing report 1)change the source to report2 in Excel or Access.
This report could be something like
"stock level & locations for product A"
parameter = SKU code & client
you can show the last date time the data was updated so users would know what time data was correct up to.

This is a viable option if the data being queried is not required to be live, but recent, and the records in report 2 table not too high for access/excel to cope with.
If you link via access, you can be saving Report 2 every hour/30 mins and the linked table in access will still work while tables update.

We have many queries in CE/Infoview that work like this.
It's not the best solution techically, but it works

RE: Schedule a report without parameters?

(OP)
Thanks Nickie, the file this report reads has 140 million records, probably too much, but we'll look at it.

RE: Schedule a report without parameters?

Are the parameters user defined or are they something common like dates based on the current date?

-Dell

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

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