Hi All, here is yet another one of my sporadic problems:

  
CPY017 PLT017 DIV017 MIN_DATE MAX_DATE SCA017 CTL017 IDT017 IV#017 PK#100 CPO017 CAR017 SM#017 BL#017 TCK100 AR$017 TD$017 DS$017 QTY017 CS$017 
1 1 10 120202 120202 NY 258831 20212 136944 350684 JENNA S12 UPS 95770 315429 1Z5RW1020347993816 155.47 .00 -95.20 3 .00 
1 1 10 120202 120202 NY 258831 20212 136944 365463 JENNA S12 UPS 95770 315429 1Z5RW1020346625868 155.47 .00 -95.20 3 .00 
1 1 10 120202 120202 NY 263313 20212 136946 350692 SCOTT SHAW S12 UPS 95770 315430 1Z5RW1020347623028 34.62 .00 -21.20 1 .00 
1 1 10 120202 120202 NJ 258597 20212 136947 350693 JOE S12 UPS 95770 315435 1Z5RW1020346862889 119.40 .00 -79.60 4 .00 
1 1 10 120202 120202 NY 258621 20212 136948 365294 TED S12 UPS 95770 315433 1Z5RW1020348178071 135.87 .00 -83.20 1 .00 

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,

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 

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,

Can you post the code ?

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'