Re: [sqr-users] No Data

["Jeffrey Bedell" <Jkbedell@syr.edu>]

We run into this a lot.  We have a batch scheduler that you pass a parameter 
that says whether or not a report is produced and if it is produced to print 
it.  Should you run a job that should print a report but no records were 
selected, the job abends even thought the SQR executed successfully.  The way 
around this is to always force at least one print line.  Set a counter to 0 at 
the beginning of the program and increment it everytime you print a report 
line.  As your last routine in the program, check the counter.  If the counter 
= 0 then print a line "No records selected".  This way you will always print a 
report.

Jeffrey K. Bedell
Senior Systems Analyst
Information Systems
Syracuse University
(315) 443-9273

>>> Ryan_Paul@aismail.wustl.edu 11/20/02 03:30PM >>>
Hello again!
     I was wondering if anyone had any suggestions on how to handle a
report that has no data.  If a report runs and there is no data I want to
print a page (preferrably with headings) that says there was no data for
the report.  Is this a situation where I should check the sql stats to see
if any data is retrieved, or should this be a .sqc of some sort?   Any
suggestions or ideas?  Thanks!

Ryan

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users