Ad Hoc - Closing or Title Companies

List Command:

LIST DA WITH STATUS = "P" AND WITH CLOSE_PERIOD BETWEEN %YEAR%02 AND %YEAR%02 AND WITH TYPE # 'O' AND WITH CLOSING_VENDOR_NAME > 0 BY CLOSING_VENDOR_NAME BREAK-ON CLOSING_VENDOR_NAME DATE_CLOSED TYPE CLASS STREET_NO PROPERTY AGENT_NAME TOTAL UNITS TOTAL PRICE TOTAL LOAN_AMOUNT

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.