I have a report that has 12 columns.  I need help on suppressing the some datas in the 3 columns and not suppressing the whole line of the detail section.  Example of my report:

f name  l name   address      tel no. zipcode occupation working? wages
john        doe     123 quack   xxx      xxxxx      postman     no           12
jane      saburit   789 doc      xxx      xxxxx      stamper     no            08
james     bond    007 bondst  007    00007     agent         yes           24

james    wood     123 holly     xxx      xxxxx      actor         yes            24

brad       pit          456 w holly  xxx    xxxxxx     actor          no            50
angelina  jollie      888 w holly  xxx    xxxxxx     actress      no            50

my problem is just suppressing the first and or second lines but suppressing only the datas under columns zipcode, occupation and working? but not suppressing the whole detail line and leaving only the last lines with full data.  Desired result should look like this:

f name  l name   address      tel no. zipcode occupation working? wages
john        doe     123 quack   xxx                                                       12
jane      saburit   789 doc      xxx                                                       08
james     bond    007 bondst  007    00007     agent         yes           24

james    wood     123 holly     xxx      xxxxx      actor         yes            24

brad       pit          456 w holly  xxx                                                     50
angelina  jollie      888 w holly  xxx    xxxxxx     actress      no            50

please help me attain this result, thank you
3jmj

DATE:  WRK CTR:  JOB:  OP NO:  LOT: SETUP:  HRS: VAR:  RUNNING?  %ACT TO STD:  EARNE/LOSS

4/29/09 1.110.01   0002141  10       001   25.00   7.00   18.00    NO        28%          1080.0

4/30/09 1.110.01   0002141  10       001   25.00  1700   8.00     YES       68%          480.00

 

4/29/09 1.115.11    0002093 10       001   12.00   2.00   10.00    NO        17%           500.00

4/30/09 1.115.11    0002093 10       001   12.00  8.00   4.00     NO        67%           200.00

 

4/28/09 1.115.04   0001516  10      002   12.00   4.00   8.00     NO         33%         400.00    

4/29/09 1.115.04   0001516  10      002  12.00    5.50   6.50     NO         46%         325.00

4/30/09 1.115.04   0001516  10      002  12.00   15.50   (3.50)    YES        129%        (175.00)

 

4/29/09 1.130.17   0001278 10      005  14.00    2.00   12.00    NO          14%           540.00

4/29/09 1.130.17   0001278 10      005  14.00    5.00   9.00     NO         36%          405.00

 

_________________________________________________________________________________________________

Above this line is exactly how my report looks like.  To answer your questions, I do have have groupings and they are wrk ctr, job, op no and lot.  Regarding suppressing some fields, I only want to show the last line per group.  You will notice that I did not include the employees, coz they are immaterial here.  Per job can have different employees working on it per day.  I need the rest of the information but some of the fields I don't want to show.  I don't know if I am making myself clear.  Using my report above, suppressing some fields, my report will look like this:

DATE:  WRK CTR:  JOB:  OP NO:  LOT: SETUP:  HRS: VAR:  RUNNING?  %ACT TO STD:  EARNE/LOSS

4/29/09 1.110.01   0002141  10       001   25.00   7.00  

4/30/09 1.110.01   0002141  10       001   25.00  1700   8.00     YES       68%          480.00

 

4/29/09 1.115.11    0002093 10       001   12.00   2.00  

4/30/09 1.115.11    0002093 10       001   12.00  8.00   4.00     NO        67%           200.00

 

4/28/09 1.115.04   0001516  10      002   12.00   4.00  

4/29/09 1.115.04   0001516  10      002  12.00    5.50  

4/30/09 1.115.04   0001516  10      002  12.00   15.50   (3.50)    YES        129%        (175.00)

 

4/29/09 1.130.17   0001278 10      005  14.00    2.00  

4/29/09 1.130.17   0001278 10      005  14.00    5.00   9.00     NO         36%          405.00

 

PLEASE HELP

 

 

I am getting an error stating:

"the remaining text does not appear to be part of the formula"

 

these are the formulas I tried but all gave me the same error:

 

NEXT{@VARIANCE}

 

NEXT{@VARIANCE}={@VARIANCE}

 

NEXT{@VARIANCE}={@VARIANCE};

 

NEXT{@VARIANCE}={LX.LX_MOSJOB}

 

NEXT{@VARIANCE}={LX.LX_MOSJOB};

 

NEXT{LX.LX_MOSJOB}={@VARIANCE}

 

next{LX.LX_MOSJOB}={LX.LX_MOSJOB}

 

all of the above i got the same errors, please help

 

i did what was told: 

This is really great but the issue i am facing now is it is inconsistent.  It is doing it on some but on some it will completely suppress the last line as well.  Plesae help, how can we tell it to always leave the last line per group even if the detail line is 1 or 2 or 3 and so on.  If it only has 1 detail line to leave it and don't suppress.  At the moment its inconsistency is suppressing also the last line immaterial of how many detail lines it has.

Example:

DATE:   WRK CTR:   JOB: OP NO: LOT:  SETUP:  HRS: VAR: RUNNING? %ATO S:   EARNED(LOSS)

4/29/09 1.110.01     0002141  10    001   25.00   7.00    

 

4/29/09 1.115.11     0002093  10    001   12.00   2.00   

4/28/09 .115.04     0001516  10    002   12.00   4.00