I am wondering if there is a way to increment a step without the step actually being there?

Example:
I have a report that is grouped by a sequence ID in this sequence ID i have 23 steps in total each step may have a work order number in it however may not actaully be in every step. Say step 1 in near completion of a work order what i want to show is the next step this work order will advance to. From a coding perspective what i want to see is IF current_step (step 1) >450 then next step (step 2)

Can anyone help me out with this logic.

please explain ur logic in detail

Ashu

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