Solved

SSRS and looping through parameter selection

Posted on 2014-12-23
2
437 Views
Last Modified: 2014-12-24
Is there a way to create a SSRS report and have it loop through a distributuon dataset?  I want to be able to run the report, publish it and then send it via email to each member of the distribution list.  The data on the report will change for each member of the group.

Can this be done using SSRS?  

Thanks

Glen
0
Comment
Question by:GPSPOW
2 Comments
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40516358
Hi,

I think you should opt for Data Driven subscription ...
0
 

Author Closing Comment

by:GPSPOW
ID: 40516636
I will look into this and try to learn how to do it

Thanks

glen
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question