Create a class , create a database table with view name from database, map the columns in external mapping of the class, then create report definition on the class created above