QUESTION:
Is it possible to use Freeform SQL reports for Dynamic Address List in Distribution Services in Strategy 9.x?
ANSWER:
It is not possible to use Freeform SQL reports in Dynamic Subscriptions. Dynamic Subscription definitons need to be mapped to specific Strategy Attributes. Freeform SQL reports do not use Strategy Attributes and so cannot be used to map the Dynamic Subscription definitions.
See the following technical note for more information on dynamic subscriptions:
KB41561: How to setup dynamic address list for Distribution Services subscriptions in MicroStrategy 9.3.x and newer
