Busy Cursor while report is generating
Posted on 2006-07-12
Using Oracle forms and reports 6i on a Windows XP workstation I wanted to have the Forms display the hour glass (busy cursor) while the report is being generated.
Right now there a few report that that a bit of time to execute. IE the user presses the button and the report comes back 5-10 seconds later.
The issue is that the user presses the button the icon switch to the hour glass for a second and then control is returned the forms. 5-10 seconds later the report is produced in the background or pops to the front. The typical user request the report and the since it does not come up instantly and the cursor is not showing as busy they press the button again, and again, and again, and again.....
When the user presses the button to request the report I would like to be able to display the hour glass until the report has been fully generated.
I would tend to think that Oracle Forms would have to monitor the system and watch for the report to be generated. Maybe there is a better way?
Is it even possible and what would you do (coding would be useful).