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!

Footer for Empty report

Status
Not open for further replies.

webfocusraj

Programmer
Aug 24, 2003
14
0
0
US
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top