I don't know how to create detailed columns total like below :
Year 2000 2001
-----------------------------------
Paris CA 100 110
Marge 30 30
Budget 20 25
Londres CA 120 100
Marge 35 30
Budget 25 25
NY CA 230 200
Marge 30 40
Budget 60 70
-----------------------------------
TOTAL CA 450 410
Marge 95 100
Budget 105 120
-----------------------------------
Is It possible with wf ? Thank you in advance.This message has been edited. Last edited by: Kerry,
WebFocus 7.7 (DB2 Web Query 1.1.2). IBM i
January 15, 2012, 04:06 PM
Waz
Yes.
The Macgyver technique will do it.
There are many posts on the subject, but in a nutshell, you effectivly duplicate the records in the report, but can assing one set to the totals and the other to the detail.