Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Preventing duplicate results when returning Maximum

Hi,

I am building a report in CR XI.  Initially the report was built as follows:

Action ID | Meeting Date | Due Date | Completed Date

___________

(SUBREPORT)

Action Date

Action Note

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:

maximum({tblActionSheetNote.actionDate},{@ActionID})

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?

Thanks

Simon

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question