Thanks for your help tindog.

I haven't been able to figure out why the report sometimes misses data.

If I could ask one more thing, what would the syntax of the execute...

I can, but it seems a waste of resources to have this subscription running every minute or every few minutes with only sporadic data to capture. I have another...

Thanks for your response.

Wouldn't an Agent job basically work the same as a data-driven SSRS subscription? At a scheduled time, the database is queried and if the conditions are...