I have a “Right Mouse Button” menu item to generate a quick report. Is there a way to have a menu click automatically generation the Export to Excel function for a quick report? My user has to click several more buttons to send it to excel and that is what I want the menu item to do.
We are on Apps 10, Update 10
Hi Bill,
There are several places which has the Export to Excel.
1. Business Reporting & Analysis → Ad hoc Reporting → Quick Reports
Another place to find the Export to Excel
Business Reporting & Analysis → Ad hoc Reporting → Create New Quick Report
You can further refer F1 docs.
Here it mentions about a known limitation. Export to Excel is not supported for SQL expressions which do not start with "SELECT" clause (Eg: - "WITH") due to a limitation in the PL/SQL access provider. Output channels could be used in such cases to export data to excel file.
Mino - Thanks for your post and F1 docs link. We had a customer getting an Error 502 - Bad Gateway System Exception Error when attempting to use RMB/Export to Excel instead of the Output Channels. It was happening on all of the Quick Reports where we used the “with” functionality. Wrapping the code in a “select” fixed the issue.
Hi Tracy,
Sorry, Its a limitation of PLSQL access provider. It has already mentioned in the documentation as well.
/Voshitha
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.