I am trying to solve a problem where the people set up to get subscriptions only want the report emailed if it contains data. Currently if whatever report it is does not have any data matching the report criteria they are still emailed an empty report.
I know I could add logic that basically runs the same query as the report and if @@ROWCOUNT > 0 then I could put some logic in the actually run the report and send the subscription but as a DBA that does not make sense as that is vbasically like hitting
the database twice to run the same report.
Any help would be greatly appreciated
View Complete Post