I'd like to find out what mode a report is being run in i.e. html, CSV, xlsx etc. I was hoping this capability would be in the audit package but I don't where to look.
If I can do this, I'd also like to be able to see if people are drilling down into further reports. So for example, if someone ran a report in html, then drilled through into another report, then downloaded an excel copy I'd love to be able to link that up and start to see the user journeys.
Let me know if I'm over reaching, or if this is doable.
Thanks for your help.
Perhaps there will be enough ReportOutput() function?
This function returns output format, e.g. 'HTML', 'PDF' etc.
Thanks for the reply. That's a useful function to know, but it sounds like it can only be used on the report it is included in?
I want to be able to write a report that could for example sort by frequency the output types of all reports run in the last day. Say 100 were run in HTML, 50 in XLSX, 20 in PDF etc.
I think I found almost what I wanted in the audit table COGIPF_VIEWREPORT which has a 'REPORT FORMAT' field. I need the equivalent for the COGIPF_RUNREPORT table, but there doesn't seem to be one which is frustrating... Anyone know where I can get that?
Thanks
Also I forgot to explain that the COGIPF_VIEWREPORT only has data on report views that have been setup, where as I want to look at all reports being run ideally.
Quote from: afroman on 16 Jan 2018 05:27:55 PM
That's a useful function to know, but it sounds like it can only be used on the report it is included in?
Yes, this function works only in the report.
We store information about the launch of each report in the DB according to the requirements of internal security (user name, launch date and time, output format etc.).
If you follow this path, you will need to add a stored procedure call to each report...
I hope you find a more easy solution for your task.