LIST DA WITH CLOSE_PERIOD BETWEEN %YEAR%01 AND %YEAR%12 AND WITH STATUS = 'P' BY PROPERTY_CODE BREAK-ON PROPERTY_CODE TOTAL PRICE TOTAL UNITS WARRANTY_ID WARRANTY_CO_ID
As is, this report will pull YTD information. If you need a different time frame, replace the %YEAR%01 and the %YEAR%12 with the four digit year and two digit month that you want the report to start and finish in.