Not knowing the data, it appears that you can move the fields to the group footer (this will give you only 1 row per group(based on OrderNo)).
I would create a formula that has shared variables, in this case boolean would work, and place it on a detail line that would look something like:
shared booleanvar Taken;
shared booleanvar Confirmed;
if left({table.field},11) = 'Order Taken' then Taken := true;
if left({table.field},15) = 'Order Confirmed' then Confirmed := true;
""//hide the output.
suppress the detail section as you don't want to see them anymore
Now you will need to reset the variables to false in the group header (another formula)
In the report, I would put 2 text boxes that each say the desired verbiage. On there General tab, Suppress, enter something like:
shared booleanvar Taken; //for example, both will look similar
Not Taken
that will 'hide' the text box if the variable is not set.
That should be all you need.
HTH
IP Logged
