Solved

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

Posted on 2011-03-14
6
484 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
  • 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

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

Accepted Solution

by:
swadhinray earned 500 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 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

19 Experts available now in Live!

Get 1:1 Help Now