Thank you @Daniele_Purrone ! I will certainly look more into this.
As for the "The user must be able to download the report in pdf format when it is suitable for them (on demand).", you can just store the reports on any place of your choice (Sharepoint, Dropbox, and so on) for the user to download.
Sorry for the confusion, the point here is that the report is generated when the user decides the data is ready. The users first need to verify that the data quality is good enough.
In your first two links, I need to find out whether the automation can send the report by email only to the user that triggered it. Alternatively, they will need to find it in sharepoint with a filename depending on the selections made and time of report generation. Or maybe there are some other clever ideas.
