Solved

SSRS and looping through parameter selection

Posted on 2014-12-23
2
394 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 14

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now