Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to schedule a report for multiple delivery(e-mail) with different parametes in SSRS 2008.

Posted on 2011-03-14
6
Medium Priority
?
506 Views
Last Modified: 2012-05-11
Hi,
       I am using a single Stored Procedure and by specifying different parametes,sending different results as e-mail to different people.Report format and the stored procedure is same,
only data defers according to the parameters.How can i schedule this in SSRS,without copying the same report.
0
Comment
Question by:mseit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 2

Expert Comment

by:swadhinray
ID: 35135426
In reporting services site you should be having a tab for for Subscriptions. Here you can automate for emailing the report or to schedule it for multiple recipient.

For setting up the email configuring on  Report Server, please find the link from MSDN site:

http://msdn.microsoft.com/en-us/library/ms159155.aspx
0
 

Author Comment

by:mseit
ID: 35136212
Hi,
   Thanks you for your comment.But the problem i am facing is different.I have a report with a Stored procedure as its dataset and i have scheduled the report as e-mail to users using subscription in SSRS.I have to send the same report with the same sp but parameters of the sp are different.(This means everything is same only the data is differnt)Report format and everything remains the same.
0
 
LVL 2

Expert Comment

by:swadhinray
ID: 35138170
ok only thing what I understood is to send the same report by executing the procedure with different parameter and sending them to others...

I am right?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:mseit
ID: 35144806
Hai,
 Yes.You are absolutely right.
0
 
LVL 2

Accepted Solution

by:
swadhinray earned 1500 total points
ID: 35145780
the best way is to do like  add your email list inside your DB.
Add another parameter for email too.
Assume that you have 4 parameter and that can vary according to the person to whom you need to send.

So add a if condition that check all the 4 param value then based on that send the report with one scheduler where you dont have to choose the email address or put any email address.

Which send to one recipient based on specific parameters.

Else create another procedure with param specific where you ca schedule it to some email address and the existing one will remain to whom it was sending to.


 
0
 

Author Closing Comment

by:mseit
ID: 35322664
pARTIALLY
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

719 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