May 16, 2016 at 9:30 am
I need a help in deciding how to get this task finish.
I created SSRS report. which is taking 4 parameters. They are as follows.
Date(By default is Today's Date)
Site (Different Office Location)
Service Provider's Name ( Agent's name who will do the service)
Type of service (Air conditioning repair, Furnace Repair, Window Repair etc)
I am able to run the report via selecting each parameter since they all are single value parameters. Now I want to email this report as an email attachment for each Provider(Agent) for their daily schedule(Next Day).
So I am hoping that I have to run the report and select each and every Site then each and every associated provider's name to the selected site and then each and every associated service to the selected providers. Here I don't have to select the day since Date will be by default Tomorrow's date which report will take as parameter.
How can I do this via some kind of SQL or SSRS tool or is there any functionality that BIDS has?
Please let me know. Thanks.
May 16, 2016 at 1:15 pm
Sounds like you could use a subscription to do this. That will handle sending the reports to each user. If you're not using Enterprise, you can use Jason Selburg's code to mimic that in a non-enterprise version of SQL Server. You have to have Agent though.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply