I remember seeing this in the old version of webfocus, either 4.3 or 5, but it seems this problem still exists in 7.6. When I use ON TABLE SUBTOTAL, the text "TOTAL" is always one row higher than the data. I know I could place

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

You are not the first to notice this phenomena and I doubt that you will be the last.
Look here.

try

TABLE FILE CAR PRINT RCOST BY COUNTRY
ON TABLE SUBFOOT 
"RCOST Totals: <ST.RCOST "
END  

ira

quote:

You are not the first to notice this phenomena and I doubt that you will be the last.
Look here.

That particular thread was viewed 18,336 times. I hope Gerry Cohen took a peek once in a while.

quote:

Originally posted by ira:
try

TABLE FILE CAR PRINT RCOST BY COUNTRY
ON TABLE SUBFOOT 
"RCOST Totals: <ST.RCOST "
END  

ira

I was trying to say in my original post that this is an awkward solution because I have over 50 columns - 4 columns each month plus YTD total, and need to adjust their position one by one with stylesheet, but the left caret was cut off after I posted. Thanks anyway

quote:

Originally posted by jimster06:
You are not the first to notice this phenomena and I doubt that you will be the last.
Look here.

Thanks jimster06, I'm still walking through that thread...

quote:

Originally posted by Francis Mariani:

quote:

You are not the first to notice this phenomena and I doubt that you will be the last.
Look here.

That particular thread was viewed 18,336 times. I hope Gerry Cohen took a peek once in a while.

I'll follow and post to that thread instead, and mark this closed.

However I'd like that master thread reopened or even pinned so everybody can rant there, lol

Hi..
In one of my current requirements, I dont need the BY field Valueto be displayed in the SUBTOTAL caption. I just want the word total.

 
ON COUNTRY SUBTOTAL AS 'Total'

It needs to be displayed like, "Total" alone, instead of Total England, Total France etc.

I cant go for Subfoot, because the number of columns is very high, nearly 30+.

Any suggestions on getting this done ?

You can add an empty sort field

DEFINE FILE CAR
  DUMMY/A1='';
END

TABLE FILE CAR
  SUM 
    DEALER_COST
  BY COUNTRY NOPRINT
  BY DUMMY   NOPRINT
  ON DUMMY SUBTOTAL AS 'Total'
  BY CAR
  BY MODEL
END

Hi Freste,

Thank you for the suggestion. That worked perfect. Thank you.