I want to report on the leads and other custom objects which have notes associated with it.
There has been a step forward regarding reporting on notes.
There is a lot of excitement going on with the Lightning Experience. However enhancements for taking notes have also taken place. There is a new version of Notes that was published with Winter 16 and you can report on them.
- Salesforce help doc on reporting on New Notes: link
- Salesforce doc on differences between the New Notes and the Old Notes: link
- Salesforce help doc on setting up the New Notes: link
- See the Winter 16 Release Notes regarding "Notes": link
The New Notes are being handled as Files objects and therefore from a reporting stand point, it looks like it lacks in providing the association between a note and an object.
It is not possible to report on Notes. There is an Idea, Reporting on Notes & Attachments that requests this feature.
You could export the data and report on it outside of Salesforce, build a custom page, query for it via the API from an outside app, etc., but there is no native report functionality available.