Supression works fine at the subtotal level but fails to work on my subheader...is there a known issue with using this structure on a header?

.
.
.
ON HOLDDETAIL.CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT HOLDDETAIL.CUSTGRP3 IN ('Other Stats', 'Other Rev');

ON HOLDDETAIL.CUSTGRP3 SUBFOOT
" "

ON HOLDDETAIL.CUSTGRP2 SUBHEAD "WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'

ON HOLDDETAIL.CUSTGRP2 SUBTOTAL AS ''
WHEN NOT HOLDDETAIL.CUSTGRP2 IN ('wRVUs', 'Units','Salaries','Charges','Panel Size','Other Stats','Addendum');

ON HOLDDETAIL.CUSTGRP2 SUBFOOT
" ".
.
.

It fails to suprress the Sub header when the value = 'Addendum'.

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

ON HOLDDETAIL.CUSTGRP2 SUBHEAD "WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'

..there was a typo in my post..should have read:
ON HOLDDETAIL.CUSTGRP2 SUBHEAD WHEN NOT HOLDDETAIL.CUSTGRP2 EQ 'Addendum'

this does not work either:

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"

not sure why my cut/paste not working...should have read...'this is not working either...'

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"

one more time...

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD

..note I have quotes around

must be an html thing....

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"CUSTGRP2"

(have a less than sign before CUSTGRP2 in actual code)

CLOSED*****

Robert, please use [ CODE ] tags (without the spaces) around your code snippets so they get properly rendered.

A conditional subhead would look like this:

ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"My subhead here"
WHEN HOLDDETAIL.CUSTGRP2 NE 'Addendum'

Thanks I will try that.

for some reason that does not work...it still shows the header even when it equals 'Addendum'

Similar code works at the subtotal level just not at the subheader.

Please test this code:

TABLE FILE CAR
PRINT COUNTRY AND CAR AND MODEL
BY COUNTRY
ON COUNTRY SUBHEAD
"Country: <COUNTRY"
WHEN COUNTRY NE 'JAPAN'
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
END

You should get a SUBHEAD for each COUNTRY except for JAPAN.

quote:

TABLE FILE CAR
PRINT COUNTRY AND CAR AND MODEL
BY COUNTRY
ON COUNTRY SUBHEAD
"Country: WHEN COUNTRY NE 'JAPAN'
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
END

That works in the CAR file. Itried and see it. It does not work in my file. I'll try pasting my code in again...

[TABLE FILE HOLDDETAIL
SUM
HOLDDETAIL.HOLDDETA.TTLAMT/P20.2CB AS 'Ttl'
BY LOWEST CUSTGRP3SORT NOPRINT
BY LOWEST CUSTGRP3 NOPRINT
BY LOWEST CUSTGRP2SORT NOPRINT
BY LOWEST CUSTGRP2 NOPRINT
BY LOWEST CUSTGRP1SORT NOPRINT
BY LOWEST CUSTGRP1 NOPRINT
BY LOWEST SORTNBR NOPRINT AS 'Sort'
BY LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'

ON CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT CUSTGRP3 IN ('Other Stats');
ON CUSTGRP3 SUBFOOT
" "
ON CUSTGRP2 SUBHEAD
"

I am note sure what code tags are...I can not get my actual code posted, perhaps if someone tells me how I will post it. I though it was simple as putting '[' and ']' around the code.

one last try...wish they had a preview on this forum!

[TABLE FILE HOLDDETAIL
SUM
HOLDDETAIL.HOLDDETA.TTLAMT/P20.2CB AS 'Ttl'
BY LOWEST CUSTGRP3SORT NOPRINT
BY LOWEST CUSTGRP3 NOPRINT
BY LOWEST CUSTGRP2SORT NOPRINT
BY LOWEST CUSTGRP2 NOPRINT
BY LOWEST CUSTGRP1SORT NOPRINT
BY LOWEST CUSTGRP1 NOPRINT
BY LOWEST SORTNBR NOPRINT AS 'Sort'
BY LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'

ON CUSTGRP3 SUBTOTAL AS '*'
WHEN NOT CUSTGRP3 IN ('Other Stats');
ON CUSTGRP3 SUBFOOT
" "
ON CUSTGRP2 SUBHEAD
"

no dice!

Robert,

quote:

no dice!

You will get the tags for code by clicking on the right-most button in the reply post. It is easy to find as it is the only one in red.
Post your code with it and then we can try and help.

Robert: If you look at the little icon bar above where you enter your message you'll see a button at the extreme right.

Click that and you will see the code tags. Just insert your code between those two tags. (You don't have to use the button - you can just type the respective tags at the top and bottom of your code).

code:

TABLE FILE HOLDDETAIL
SUM 
     TTLAMT/P20.2CB AS 'Ttl'
BY  LOWEST CUSTGRP3SORT NOPRINT 
BY  LOWEST CUSTGRP3 NOPRINT 
BY  LOWEST CUSTGRP2SORT NOPRINT 
BY  LOWEST CUSTGRP2 NOPRINT 
BY  LOWEST CUSTGRP1SORT NOPRINT 
BY  LOWEST CUSTGRP1 NOPRINT 
BY  LOWEST SORTNBR NOPRINT  AS 'Sort'
BY  LOWEST DETAIL_GRPNM AS ' '
ACROSS LOWEST FY AS ' '
ACROSS LOWEST RPTBANBR AS 'Cost Centers'
     
ON CUSTGRP3 SUBTOTAL AS '*'  
WHEN NOT HOLDDETAIL.HOLDDETA.CUSTGRP3 IN ('Other Stats');

ON CUSTGRP3 SUBFOOT
" "

ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 " WHEN CUSTGRP2 NE 'Addendum'

ON CUSTGRP2 SUBTOTAL AS ''  
WHEN NOT CUSTGRP2 IN ('wRVUs', 'Units','Salaries','Charges','Panel Size','Other Stats','Addendum','FTEs');
.
.
. 

All Subtotal supression works fine. Subhead...not so good....does not supress on: 'Addendum'

Robert,

This worked for me:

  
-* File Robert2.fex
TABLE FILE CAR
SUM SALES
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY BODYTYPE
ACROSS SEATS
ON COUNTRY SUBTOTAL AS '*'
WHEN NOT COUNTRY IN ('FRANCE')
ON COUNTRY SUBFOOT
" "
ON CAR SUBHEAD
"<CAR "
WHEN CAR NE 'JAGUAR'
ON CAR SUBTOTAL
WHEN NOT CAR IN ('JAGUAR', 'MASERATI')
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT, $
ENDSTYLE
END

I believe you...just not sure why my code does not!

If I may suggest, try some good old fashioned salami debugging: cut out all the superfluous, see that you get what you want and then add slice by slice...

[quote]
ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 " WHEN CUSTGRP2 NE 'Addendum'
[quote]

RobertF, your code doesn't follow the syntax we suggested. The WHEN clause should be on a line of its own!

Try this:

...
ON CUSTGRP2 SUBHEAD
"<CUSTGRP2 "
WHEN CUSTGRP2 NE 'Addendum'
...

I think that was it...the WHEN on its own line...but I dicovered the solution thru another means that made no sense to me...so thanks for the post!

I whittled my code down to this:

 TABLE FILE HOLDDETAIL
BY  HOLDDETAIL.HOLDDETA.CUSTGRP2
     
ON HOLDDETAIL.HOLDDETA.CUSTGRP2 SUBHEAD
"<CUSTGRP2"  WHEN CUSTGRP2 NE 'Addendum';
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END 

It was still acting up. So changed the report type to HTML. It worked. I then changed it back to Excel...to my surprise..it worked. It appears the GUI somehow dropped the WHEN to its own line. At least I understand it now..I was thinking it was some sort of bug.

THANKS ALL!!!