Focal Point
[CLOSED]Footing with emty table

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3107006926

March 19, 2013, 11:26 AM
MichaelBalle
[CLOSED]Footing with emty table
Is it a bug or a feature - or the other way round:
Is there a possiblity displaying footings with an empty table (the same result when using SUBFOOT)?

If the table is empty, the headings are displayed correctly - the footings are not:

  
TABLE FILE car
   SUM
     DEALER_COST
     RETAIL_COST
  BY COUNTRY
  BY CAR
  BY MODEL
-*
  WHERE COUNTRY EQ 'EGAL'
  HEADING
    "This is the first heading"
  FOOTING
    "This is the first footing"
-*
  ON TABLE SET EMPTYREPORT ON
END

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


WebFOCUS 7.6, 7.7
Windows, All Output formats
March 19, 2013, 11:31 AM
FrankDutch
It has to do with a setting like
SET EMPTYREPORT=ON or ANSI

Give it a try




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

March 19, 2013, 11:44 AM
MichaelBalle
Thanks to Frank,

it works with "ON TABLE SET EMPTYREPORT ANSI"
it doesn't work with "ON TABLE SET EMPTYREPORT ON"

Thanks a lot and have a nive day (evening for europeans ;-)


WebFOCUS 7.6, 7.7
Windows, All Output formats