Is there a way to export the generated reports to PDF or word document to share via email or Dropbox?

Search on the Shared Components Record here on Forum for plug-ins that allow exporting data:

- Download DataSubset
- Export SQL and Report Data to EXCEL - V2

You will have to then convert this to PDF building your own plug-in. There's one to convert Word documents to PDF but not Excel to PDF:

- Dynamic Document Generator

What about the diagrams on the report. Is there a way to export it too?

You can use an add-on in any web browser to print the screen in PDF format.

Thanks Eduardo!