I am trying to create a multi-verb request, where the last 5 fields (AR#017, etc.) should be prohibited on subsequent lines (they are unique by the IV$017 field) but still print the repeated date for the other columns.
Is there a way to make this work?This message has been edited. Last edited by: Lloyd,
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
October 15, 2012, 01:53 PM
Danny-SRL
Lloyd,
1. Why a multi-verb? 2. As for your AR$017 fields, you can use a COMPUTE with the LAST function:
COMPUTE SAR$017/format = IF IV$017 EQ LAST IV$017 THEN ' ' ELSE AR$017; AS AR$017
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
October 15, 2012, 03:06 PM
Lloyd
quote:
Posted October 15, 2012 01:53 PM Hide Post Lloyd,
1. Why a multi-verb? 2. As for your AR$017 fields, you can use a COMPUTE with the LAST function:
COMPUTE SAR$017/format = IF IV$017 EQ LAST IV$017 THEN ' ' ELSE AR$017; AS AR$017
1. I tried to use a multi-verb as that was the only way I could think of doing it. (I am only an occasional WF programmer/user, so some times my brain forgets how to do things...)
2. Never used the last verb before, but I think that's exactly what I was looking for....
gonna try it out and let you know how its goes...
Yup, was exactly what I wanted, thanks Danny!....This message has been edited. Last edited by: Lloyd,
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
October 15, 2012, 04:34 PM
Waz
Can you post the code ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 15, 2012, 05:37 PM
Lloyd
The code is just as Danny explained, rather than creating a multi-verb report, I just did a natural sum, and used the LAST verb/function to only print the values once, :
COMPUTE SAR$017/A15 = IF IV#017 EQ LAST IV#017 THEN ' ' ELSE FTOA(AR$017, '(D12.2)', SAR$017); AS 'INVOICE, DOLLARS'
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com