1

I have a user who is requesting that a legacy report (email subscription) that runs with multiple categories be modified to run based on which categories exist in the given date range. Thus instead of one email with daily details on:

Widget 1 
Widget 2 
Widget 3
Widget 4

They would like 4 separate emails with just Widget n.

The kicker is that in any given day, there can be a subset of Widget n details in the schema and they only want an email if details for those widgets exist.

Is this even possible with SSRS? I can do a data-driven subscription I can't quite figure out how to fire the report multiple times for each existing widget in that day.

1

In a data-driven subscription you specify a query. Each row that the query returns corresponds to a single email, rendering a new report for each one.

So have your query do something like: SELECT WidgetID FROM dbo.Widgets

...or if it's already doing that, use CROSS JOIN dbo.Widgets to make your query return four times as many rows (assuming there are four).

Then use the WidgetID field as a parameter to your report.

  • Thanks. So that just naturally sends the email x times (where x is the number of times Widget 1 occurs in the table for that time period)? – swasheck Feb 20 '12 at 23:14
  • 1
    To answer the question - yes. It does. That's awesome. Thanks Rob. – swasheck Feb 20 '12 at 23:40
  • Yes - but I guess you've figured that out. :) – Rob Farley Feb 20 '12 at 23:48
  • 1
    Be advised that you'll need Entrprise Edition (or Developer) to use data-driven subscriptions. It's an excellent feature if you've got it, though. – db2 Feb 21 '12 at 1:29
  • Thanks db2 - the question does mention that Data Driven Subscriptions is an available feature. – Rob Farley Feb 21 '12 at 4:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.