Focal Point
[SOLVED] Totals on 2 Lines (use subfoot instead, but ... decimal place problem)

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

November 12, 2008, 12:59 PM
MTO-Solutions-Engineering
[SOLVED] Totals on 2 Lines (use subfoot instead, but ... decimal place problem)
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)
November 12, 2008, 02:02 PM
Mighty Max
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



WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
November 12, 2008, 02:58 PM
MTO-Solutions-Engineering
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


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)
November 12, 2008, 03:54 PM
Francis Mariani
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.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 13, 2008, 08:06 AM
MTO-Solutions-Engineering
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


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)