Implement the ability to add filters in reports that only return X related records

Idea created by Brad Koch on Oct 29, 2015
    • Kevin Cook
    • Shijin Krishna
    Sugar Professional
    On Demand
    I have a report that grabs Accounts based on a few criteria.  Part of the display of the report are the related records in the NOTES module.  Some accounts have a lot of notes.

    Can I add any logic to allow me to only pull over and display that 'last 5 notes'?  

    I tried doing it based on a time period.  That did not work because some accounts have not had any notes in a few months and would be excluded if I set the Date to catch only notes in the last 30 days.  

    Ideally, I would like an option to define a filter of "last x records".

    Thanks in advance for any suggestions.