Hi

i been a report in crystal by sql query, that return something like

Concept   Qty.        Unit              Details
Name 1     35           inch             detail 1
Name 1     35           inch             detail 2
Name 2     23           pound            detail 1
Name 3     10           pound            detail 1

i try no repeat the concept, qty and unit, i want to show something like

Concept   Qty.        Unit              Details
Name 1     35           inch             detail 1
                                         detail 2
Name 2     23           pound            detail 1
Name 3     10           pound            detail 1

I tried the Suppress is duplicate option, that works by the first column because it never repeat, but the next columns doesnt works, in the example suppress the last two units and that cant be

I tried to find a way to know if an object is suppressed, and suppress the next columns, also i tried with control = previous(control) and control = next(control)

the first one suppress all repeat item and the next suppress the first items

Any sugestions?

regards

No, they no duplicate, just duplicate the first three columns and is correct, because my query are head and detail and all the fields (the first three) are head and the last column is detail, i want suppress the headers columns without use group section

regards

If it's being caused by your joins then go to the section expert and place this in the formula field of "Suppress (No-Drilldown) :


{table.field}=previous({table.field})

This is where your {table.field} are the join.

Leave the check box unchecked.