On Wed, Mar 16, 2011 at 9:04 AM, Greg Keogh <g...@mira.net> wrote: > Folks, our customer needs a facility to generate reports via calendar > schedules and then distribute them to lists of email recipients. For > example, on the first of each month, monthly summary reports with filtering > arguments for different customers and departments would be generated and > each would be emailed to one or more related people. They currently do this > by hand and it's a growing burden on the staff. > > > > One of us discovered that SQL Server with Reporting Services (SSRS) seems to > do everything we need, so we upgraded to SQL Server Express with Advanced > Tools (and reporting) and ran some experiments to make RDL server-side > reports and use the web interface to publish and generate them. This all > works, and we got excited, but then discovered that subscription reports are > not a part of SQL Express editions, so we don't get the facility to schedule > and distribute reports unless our customer upgrades to the SQL Server > Enterprise edition which is about $27000 per processor. > > > > So we have to tell the customer to buy SQL Server Enterprise and we learn > how to use SSRS, or we find some other way of creating the > subscription/schedule facility. Our current preference is for the latter if > there is a way of programmatically generating the RDL reports stored on the > server. If we can generate the reports, then we're quite happy to wrap it in > a scheduler (NCron, Quartz .NET, etc) and it's easy to send email > attachments. That way, SQL Server holds all the report definitions and data, > and our code schedules and distributes the reports. > > > > Does anyone know if there is an API or service into SSRS to allow us to > generate the RDL reports? >
Yes I believe the SSRS web service lets you do that. > > > Any other general comments on this matter would be welcome. > > > > Cheers, > > Greg