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.
The Salesforce link on creating reports has changed from above and it took a bit of digging to find it again, so posting here: Create a report on Notes