Footer for Empty report

webfocusraj · Oct 21, 2003

Hi,
I created a report for which I want to display the empty report (including report footer) when the where condition is not satisfied.
For that I used SET EMPTYREPORT=ON
Then, I am able to see the column titles with no data.
But, I am unable to see the report footer !!
I want to see report footer also. Is there anyway for that?
Thanks in advance.
-WFRAJ

mmiles · Mar 15, 2004

Case: 32261090 Product: MF Release: 706 Primary OS: MVS Date: 98/08/24
Case information refers to the Product, Release, and OS for which this question was asked. The solution may apply to other Products, Releases, and Operating Systems.

Symptom:

How to print a report that will contain Footing information if the report does
not have data.

Problem:

SET EMPTYREPORT = ON prints HEADINGS not FOOTINGS.

Solution:

This is expected behavior with this command.

Product: MF, MF, FOCUS/S390
Symptom: None Assigned
Functional Area: None Assigned
Operating System: MVS, MVS
Keywords: 32261090, FOOTING, EMPTYREPORT
Docid: 32261090

WFGuru · Mar 17, 2004

If this is an HTML report, you can do this for a workaround.

SET EMPTYREPORT = ON
TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
ON TABLE SUBFOOT
"End of Report"
IF COUNTRY EQ 'XXX'
END
-IF &RECORDS GT 0 THEN GOTO NOFOOT;
-HTMLFORM BEGIN
End of Report
-HTMLFORM END
-NOFOOT

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!

Footer for Empty report

webfocusraj

Programmer

mmiles

Programmer

WFGuru

Vendor

Similar threads

Part and Inventory Search

Sponsor