Preventing duplicate results when returning Maximum
I am building a report in CR XI. Initially the report was built as follows:
Action ID | Meeting Date | Due Date | Completed Date
This report would provide details on action items that came out of committee meetings. There were often multiple notes for each Action ID.
The report was running fine as it was. If I ran it for January, it would return 10 results.
I was asked to add a heading between Due Date and Completed Date to display the last Action Date. I have created a Group based on Action ID and then created a formula to find the following:
I then placed the formula field into the report between Due Date and Completed Date. The formula returns the last date for each Action ID, but now when I run the report for January it returns 18 results. When I look at the data in the report, it is displaying multiple results where there are multiple notes for an action (ID 123 has 3 notes so appears 3 times in the report).
Has anyone got any suggestion about how I can provide the action date without ending up with multiple Action ID results?