June 6, 2011 at 1:32 am
I'm new to reporting services. Is it possible to make one report to send reports for all users one by one? I mean can I use reporting services to generate more than one report and send them separatly?
Here is the real story;
I have a customer with ~2000 workers, some of them are managers. They want me to send reports for all the users separately (each user will have his own report) and managers should have reports for their workers, monthly.
Number users and/or managers may change, so I cannot make certain number of reports.
Thank you.
June 6, 2011 at 7:21 am
You may need 2 reports, it is not clear. One maybe for the managers, and another for the users. Assuming the report(s) have the necessary input parameters to make them flexible enough so that they can show data for each user you can build a data driven subscription to email a user/manager specific report out to each user/manager.
June 6, 2011 at 10:30 am
My question is how do I use report service to send N number of reports, while N can be changed. And in my case it is ~2000.
So is it possible to use report service to send 2000 report/email each month automatically (noone will change the parameter and send the report for all the users)
For the managers, it will be like this:
Get list of managers,
Loop through managers (
Get workers of the manager
Prepare report & send email
)
This is also same problem. Managers & workers can be changed every month so I cannot make a constant report.
More clearly "can I loop on parameters values" to send multiple reports?
Is it more clear now? Sorry for the bad english.
Thanks.
June 7, 2011 at 12:36 am
Hi,
Probably you need to create Data-driven Subscription for this. If the data is going to be changed based on user, i mean manager or workers under him then you need the parameters accordingly in the report which can be configured to pick from the database while creating the data driven subscription.
Regards
Dileep
June 7, 2011 at 3:17 am
Thank you very much. I'll try to find more resource on data driven subscription topic.
I found something, it may help others as well:
http://msdn.microsoft.com/en-us/library/ms157252.aspx
http://www.codeproject.com/KB/reporting-services/PDFUsingSQLRepServices.aspx
http://qa.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/
http://www.bigresource.com/Tracker/Track-ms_sql-Mtlzpvvo/
Thank you.
June 7, 2011 at 4:34 am
Data-driven subscriptions are only allowed in Enterprise, also I'm not sure they'll do what you want. It would probably be better to put together a custom script (or even SSIS) and an agent job to handle it.
June 7, 2011 at 10:00 am
Yes that is exactly what I want. Thank you very much.
In this article it is explained well: http://msdn.microsoft.com/en-us/library/ms169673.aspx
June 29, 2011 at 9:21 am
Hi,
Yes you would do this through data driven subscriptions and you could use one report and one subscription to burst the reports the users.
if you have the manager details in the database this should be straightforward.
One thing I would say is to make sure you do a test run to yourself, you wouldn't want an incorrect report to be sent out to 2000 users 😉
July 1, 2011 at 12:54 am
Abs-225476 (6/29/2011)
One thing I would say is to make sure you do a test run to yourself, you wouldn't want an incorrect report to be sent out to 2000 users 😉
This just happened this morning! 😀 Shame on me 😛
July 1, 2011 at 2:39 am
I know the feeling, as long as the data only relates to the user then it won't be too bad. You should be be able to resend the emails with a message saying 'Please ignore the email sent out earlier, it was sent in error', but test it and send it to yourself first!
You have probably got quite a few emails back saying whats going on??
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply