Skip to Content
0
Former Member
Jan 04, 2008 at 11:32 PM

Suppressing duplicate value in group header.

18 Views

Post Author: alcampin

CA Forum: Formula

I am using version 10.0.5.1506 and trying to create a manual cross-tab report.

I place a formula in the detail section to accumulate a value and then in the group header I print out the supervisor, work center Group and work center with the values so I have something like this.

AP CHEMELEM 5501 xxxx xxxx xxxx

AP CHEMELEM 5502 xxxx xxxx xxxxx

AP CHEMELEM 5503 xxxx xxxx xxxxx

AP HEATTREAT 5501 xxxx xxxxx xxxxx

AP HEATTREAT 5502 xxxx xxxx xxxxx

AT CHEMELEM 5501 xxxxx xxxx xxxxx

etc.

What I want is

AP CHEMELEM 5501 xxxx xxxx xxxx

5502 xxxx xxxx xxxxx

5503 xxxx xxxx xxxxx

HEATTREAT 5501 xxxx xxxxx xxxxx

5502 xxxx xxxx xxxxx

AT CHEMELEM 5503 xxxxx xxxx xxxxx

Pretty simple.

I found a reference online that indicates to suppress in a header, I need to check the suppress if duplicate button and put a formula in like

{LOADP_Query.SUPERVISOR} = Previous({LOADP_Query.SUPERVISOR});

If I do this, nothing happens. The supervisor name always prints.

If I change to be

{LOADP_Query.SUPERVISOR} <> Previous({LOADP_Query.SUPERVISOR});

then the supervisor's name is suppressed on the first line but prints on all the rest.

This doesn't make any sense. Why would the formula work if I use not equal but not if I use equal?

I created a formula to display the previous value and it shows a blank followed the value of AP so I know it is getting the right value.

Any idea why equals would not work?

Thanks for any help.