Hi All,

I am developing a report with heading and footing. The report should display the footing at the time of empty report. But I am unable to get footing in the output. please Any body suggust me.

Thanks
KOteswar

Example;

SET EMPTYREPORT = ON
TABLE FILE EMPDATA
PRINT *
WHERE DEPT EQ ' ';
HEADING
" HAI"
FOOTING
"BYE"
END

WebFOCUS 7.6.4, Oracle 9i, Windows XP.

This message has been edited. Last edited by: Koteswar,

Instead of having footing for Empty record set, use the same code to print the Footing irrespective of the data returned. You can do this by making the report compound and appending the dummy records at the last to ensure that footing always appears on the report.

Eg:

SET EMPTYREPORT = ON
TABLE FILE EMPDATA
PRINT *
ON TABLE PCHOLD FORMAT EXL2K OPEN
END
TABLE FILE CAR
PRINT MODEL NOPRINT
FOOTING
"BYE"
ON TABLE PCHOLD FORMAT EXL2K CLOSE


Hope this helps.

Try this:

SET EMPTYREPORT = ANSI
-*
TABLE FILE CAR
 PRINT COUNTRY CAR MODEL
 WHERE TOTAL COUNTRY EQ 'SPAIN';
 ON TABLE HOLD
END
-* 
TABLE FILE HOLD
 PRINT *
 HEADING
  "Hi"
 FOOTING
  "Bye"
END

There was a similar post recently that gave several suggestions for this. Your observation that a footing is not generated for an empty report is correct. A heading can be generated, but a footing cannot. The compound report idea will work, but that just seems like overkill for something simple like this (in addition to the fact that the syntax that Swap uses is the "old" syntax and is no longer generated by the GUI tools this way.)

Best way would be something like Dan has. Run the procedure, test to see if &RECORDS EQ 0 and, if so, branch to a separate procedure that gives the output you want.

In relation to Dan's suggestion, I found this technique.

http://techsupport.information...utions/30862015.html

Actually, the SUBFOOT isn't necessary - either FOOTING or SUBFOOT will work. The reason the HOLD file was neceassry in my ealier post is because the TOTAL was inadvertently left in the WHERE clause from an earlier test.

SET EMPTYREPORT = ANSI
-*
TABLE FILE CAR
 PRINT COUNTRY CAR MODEL
 WHERE COUNTRY EQ 'SPAIN';
 HEADING
  "Hi"
 FOOTING
  "Bye"
END

Dan

Its interesting that the technique above was dated 2007, it is by no means new.



FYI

I fount the technique by using the search function here. I've found many useful things with it.

Waz, thanks for the link. First time I've seen Magnify in the real world.

I always find myself using this as a first port of call when I have an issue.

I've found some links that come out of it do not work (or are restricted)

The only real issue I've had is what words to search for.

Waz,

I am thanking you for link also, it now in favorites

I think that people not necessarily use search first but should do as Francis say here.

Other problem people no speak Engrish well and is their next language. This problem is when using Engrish based forum like this but I know people try to show help in other language like Ira and TonyA here which is good but when use Engrish based SW there requires Engrish understand.

Kofi

So it's the EMPTYREPORT=ANSI instead of EMPTYREPORT=ON that makes the difference. Using EMPTYREPORT=ON, you will not get a footing. It would be interesting to know how that setting is changing the internal processing.

Based on what I've read, when EMPTYREPORT=ON is used and no records are retrieved, then only HEADING and column titles are displayed. Both &RECORDS and &LINES are set to 0.

With EMPTYREPORT=ANSI and no records retrieved, WF "fakes" one line with values of 0 for numeric fields and blank for alpha fields. In this case, a whole report is produced (with one empty record) so FOOTING is also displayed. &RECORDS is still set to 0 but &LINES is set to 1.

I need to read again to get the facts clear but hopefully I'm not that off

Hi All,

Thanks to one and all to share knowledge with me. It is really helpful to me.

Regards
Koteswar