Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

How do I set a SSRS 2005 report to run automatically?

How do I set a SSRS 2005 report to run automatically?

The report accepts multiple parameters but I need the report to be run with only a specific parameter and to be run and emailed to someone.
0
Sanjeet
Asked:
Sanjeet
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Define 'automatically'.  The Force?  Continuously or on a schedule?
0
 
SanjeetAuthor Commented:
I would like a report to be scheduled at 5am Wednesday weekly and the results sent to 1 or 2 people.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In SSRS that would be a data-driven subscription.  

I don't have a script handy on how to pull that off, and I don't want to do a Google search and type the results here as you can do that as well, so I'll back out of this question so that other experts can reply.
0

Featured Post

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now