Removing duplicate rows from report

[n2nuk]

This is a bit of a longshot as my query relates to using Web intelligence report writer built into Business Objects.

I have recently started with a new employer who use SAP Business Objects, I am having to familiarise myself with the web intelligence tool to produce reports and have an issue with removing duplicate records.

The report lists interactions between workers and clients. as its possible that a worker will have seen a client multiple times there is a start and end date for each transaction.

I would like to list only the latest transaction, this will be the record with the latest end date. In Crystal its possible to sort the report by the end date and then apply a group that will return only the latest row.

Is this possible on Webi?
any ideas?

Many thanks

 

[kray4660]

Maybe. Webi is a very different tool than Crystal. I do not use it very often, so I am relying on fuzzy memories. You have to use a table and you can group by a value. I know that you can hide and show some elements, and depending of what version you are using, how you do some things has changed.