How can i only show one work order number in a group and supressing the duplicate work order.
Example:
I have a Group #1 called Sequence Id
I have a Group #2 called Work order Numbers
I have a Group #3 called Work order Number. yes there are two groups on the same field.
Here;s what i want to do in Group#3 (work orders) i have put a supress statment in the group field to supress every value that doesn;t match the quantity reuired.
On Group #2 i don;t put any supression formula on that group so what i end up seeing is a douple value from Group#3 and Group#2 Example:
Expected Result:
GH1 SEQ 1
GH2 WO100
GH3 WO100
GH1 SEQ 2
GH2 //supressed based on condition
GH3 WO100
Current Result:
GH1 SEQ 1
GH2 WO100
GH3 WO100
GH1 SEQ 2
GH2 WO100
GH3 WO100
Example:
I have a Group #1 called Sequence Id
I have a Group #2 called Work order Numbers
I have a Group #3 called Work order Number. yes there are two groups on the same field.
Here;s what i want to do in Group#3 (work orders) i have put a supress statment in the group field to supress every value that doesn;t match the quantity reuired.
On Group #2 i don;t put any supression formula on that group so what i end up seeing is a douple value from Group#3 and Group#2 Example:
Expected Result:
GH1 SEQ 1
GH2 WO100
GH3 WO100
GH1 SEQ 2
GH2 //supressed based on condition
GH3 WO100
Current Result:
GH1 SEQ 1
GH2 WO100
GH3 WO100
GH1 SEQ 2
GH2 WO100
GH3 WO100