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.