moved methods to retrieve data for summary reports