How can I get the last Assigned activity of a ECN displayed in the query builder.

[jbutler]

I am trying to build a report with the query builder to get the release date and resolve date of an ECN.  On this moment I have this but I get double records. I am looking for a method that give me the latest activity of an ECN.

Report information

Joins.

Select

Criteria

[Marco_Tosin]

I think you could join this group Reporting and also take a look at this document Resource for reporting

There are lots of report ready to use and also some useful tips.

[jbutler]

thanks