Checked the cause of the error in the top summary report by rack for fixing, as per checking, the data in the database is correct, but when executed the query, it is returning character value thus it is what displayed in the report, modified the application query for fixing the display in the report, tested the modified application, as per testing an error is returned, modified the application again for correcting the function used, tested the modified application again, as per testing it is now OK.