Hi,

I am trying to supress duplicate rows if the results are the same as the previous. Is there a way to query the whole row to check if its a duplicate rather than just one field? As potentially multiple fields could be the same apart from one value which would indicate this is actually a separate result not a duplicate example below:

ID Date        PurchasedBy    Item    Description Qty
1   01/01/2013   user1          Item A    1        20
1   01/01/2013   user1          Item A    1        20
1   01/01/2013   user1          Item B    1        20

If I create a section expert on the Supress no drill-down {table.item}=previous({table.item})

I still get duplicates :(


Edited by shabbaranks - 06 Mar 2014 at 1:32am

another thing you can do is converting to string the 5 columns and create a group based on that string
for example put inside {@fromula1)
totext(ID)+totext(Date)+PurchasedBy+Item+Description+totext(Qty) and group based on that formula