How to export all reports and their queries?
Hi there, How to export all reports and their queries? Thank you. I need a list of all reports for cleaning old and used reports. There are hundreds of reports in my database. Is it a better w...
Forum Discussion
Hello Ning,
I am not sure how you are currently doing it, but if you go to the Home page of the application that you are looking to clean reports from and go into Settings>App Management>Manage reports, it will provide you with a list of all the reports in that application and some critical information about those reports for decision making on whether to purge the report or keep it. Hope this helps...
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
I am not sure how you are currently doing it, but if you go to the Home page of the application that you are looking to clean reports from and go into Settings>App Management>Manage reports, it will provide you with a list of all the reports in that application and some critical information about those reports for decision making on whether to purge the report or keep it. Hope this helps...
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Hi Brandon,
Thank you very much for your reply!
Yes, I was able to see the list of all reports in App Management. It contains name, type, group, last used, used count, owner, report ID. However, I am looking for queries, the queries that create the reports. such as "billing category = supplier follow up AND date after 1/1/2019" ...........
I think the queries can provide more information to allow me make decision to keep it or delete it. Any suggestions to list queries? Thank you.
------------------------------
Ning W
------------------------------
Thank you very much for your reply!
Yes, I was able to see the list of all reports in App Management. It contains name, type, group, last used, used count, owner, report ID. However, I am looking for queries, the queries that create the reports. such as "billing category = supplier follow up AND date after 1/1/2019" ...........
I think the queries can provide more information to allow me make decision to keep it or delete it. Any suggestions to list queries? Thank you.
------------------------------
Ning W
------------------------------