Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If there is no data for the query, can Info not export the report? 1
- Thread starter jrusso
- Start date
-
1
- #2
This is not possible with vanilla Seagate Info - if a report is scheduled to run it will always product output - if there are no results then the resulting report will be blank.
What you could do is write a pre-requisite program that runs the query and returns a result code > 0 if COUNT(*) > 0, and 0 if COUNT(*) = 0. You could then set a dependancy schedule on the report so that it only runs if the pre-req job returns a result code of > 0.
Just a thought...
Cheers, Alan Eldridge
Melbourne, Australia
What you could do is write a pre-requisite program that runs the query and returns a result code > 0 if COUNT(*) > 0, and 0 if COUNT(*) = 0. You could then set a dependancy schedule on the report so that it only runs if the pre-req job returns a result code of > 0.
Just a thought...
Cheers, Alan Eldridge
Melbourne, Australia
- Status
Similar threads
- Locked
- Question
- Locked
- Question