Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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