I have a time-consuming Classic Report (that collects data from an external source via API's). Each row has an ‘Errors’ column value. This can be 0 (no errors) or 1 (has errors).
After all the data has been collected (only 20 rows) and the results have been rendered, I want to Enable a (disabled) button only when the sum of all ‘errors’ = zero (so only when the data shows that no errors have been reported). The Error column should not be visible to the user (nor should the sum of all errors be visible).
How can I do this?
I have created an application on apex.oracle.com in case you would like to work on an example:
Workspace: HUE_API
Username: FORUM_MEMBER
Password: FM200423!
Application: Application 103596 - Update Item With Report Sum
In this application, the button should be enabled when the total of the salary = 29025 ( SAL is a hidden column)
By the way, executing the same query only to retrieve the total of the salary is not the solution I am looking for. As I mentioned earlier, the actual query takes too long to be re-executed only for this purpose.