Footer for Empty report

[webfocusraj]

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]

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]

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