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.
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)