RE: [sqr-users] No Data

["Benzenhafer, Dave" <DBenzenhafer@houston.deepwater.com>]

You can put a counter like 
Add 1 to #counter 
in the main section and after the end-select use 

If #counter = 0
Print 'Do Data' (1,1)
End-if
This should print your headings.

Dave Benzenhafer
EMPAC Custom Report Writer
dbenzenhafer@houston.deepwater.com


-----Original Message-----
From: Ryan_Paul@aismail.wustl.edu [mailto:Ryan_Paul@aismail.wustl.edu]
Sent: Wednesday, November 20, 2002 2:31 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] No Data


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