Monday, March 19, 2012

Dumb question: Sanpshot reports

Will a report based on a scheduled snapshot send itself out (either to an email or data space) if the data in the new snap shot is the same as the previous?

If so is there any method to only send out a report if the data has changed?

And if not what do most people use snap shot based subscriptions for?

Thanks.

1.) Yes.

2.) You can try to use Data Driven Subscriptions. What you will have to do is have the query which generates the list of recipients detect if the data has changed, and return an empty set if this is the case. SSRS will not really help you do this, so you will need to cook up your own way of determining if the data has changed since the last report went out.

No comments:

Post a Comment