- check the error encountered in the application
- debug the application to get and check the script used in the generation of the report
- there are two stored procedure used in the generation of the report the first script has a data extracted but the second did not return a data the reason the error is encountered
- check the script why there is no data returned