Question: I need an Ad Hoc Report that shows all the Co-Brokers for the current year.
Answer:
LIST DA BY CO_BROKER WITH STATUS = 'P' AND WITH CLOSE_PERIOD BETWEEN %YEAR%01 AND %YEAR%12 BREAK-ON CO_BROKER_PAY_TO CO_AGT TOTAL PRICE
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.