I would like to know, what is the best way to test the reports in automated testing
Hewlett Packard Global Soft
By reports I assume you are talking about the results-sets/views from a DB.
Establish a connection to the DB and run your own queries for the required logic. You could validate this reports with the DB values your query returned.