wow! Lots of discussion about this. Especially at http://forums.informationbuilders.com/eve/forums/a/tpc/...571078331#1571078331.

I could not get any of the tricks to work, so I turned to the custom subfoot method. It gave me my one line totals line, but now my data has grown 2 decimal places, even though all the data involved is integer only.

How does one force subtotals (
thanks

Richard

This message has been edited. Last edited by: MTO-Solutions-Engineering,

MTO
WebFOCUS Dev Studio 5.3.2 (trying to upgrade to 7.x !)
Unix with Win XP front ends
output usually PDF (and some HTML and XLS at times)

Use a DEFINE to change the format of the field.
Example - If the field is D8.2 change it to D8.

  
DEFINE FILE CAR
SEATS/D8 = SEATS;
END

That was too easy!!! I thought that this was enough ...

PRINT
     SERV_REG AS ' '
     POLICE/D8 AS ' '
     REGISTRAR/D8 AS ' '
     TOTAL_DATA/D8 AS ' '

but obviously not.

thank you

Richard

Richard, the redefinition POLICE/D8 is good only for report columns and subtotals, not for subfoots. Mighty Max's solution will work for report columns, subtotals and subfoots.

By the way, I have lost millions of neurons trying to fix the two-line subtotal over the years. I have never found the DEFINITIVE solution, though many have tried to help. I still feel IBI should fix the problem in the software and not suggest workarounds.

quote:

Originally posted by Francis Mariani:
I still feel IBI should fix the problem in the software and not suggest workarounds.

You have our vote. This is so easy in other products that I have used (mind you, they were all desktop based, not web based, but still, this is a classic design structure)

Richard