Actually, if you set up the query in your subscription to return the email addresses you want to send out to, and set it up so it returns nothing when...

This is a SSRS forum, not an "Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 1 (11.1.1)" forum.

You can probably do this a few ways, the easyist that I can think of would be to use "Linked Reports" in Report Manager and then in your SQL code...