SQL Reporting via website

[doctorfonz]

Hi all

We current use SQL reporting on our LAN, and AD takes care of the necessary authentication. We have users at head office on the LAN plus numerous business partners who connect into a terminal server.

We are moving our database front end from an Access based application to a .NET web frontend.

Does anyone have any thoughts or recommendations about the various ways of publishing SQL reports to webpages ? ...We are using SQL 2008

Many thanks

[Mulligan]

SQL Server Reporting Services (SSRS) should allow you to publish reports by schedule, allow ad-hoc reporting and spit them out in a variety of formats and to a variety of media (e.g. email as PDF). You can use AD to control access. It's what we use for a number of our clients, though it's not 100% my bag - but our BI guy swears by it. May be worth investigating?

[doctorfonz]

SQL Server Reporting Services (SSRS) should allow you to publish reports by schedule, allow ad-hoc reporting and spit them out in a variety of formats and to a variety of media (e.g. email as PDF). You can use AD to control access. It's what we use for a number of our clients, though it's not 100% my bag - but our BI guy swears by it. May be worth investigating?

Thank you. Unfortunately, as it will be part of a web based piece of software, AD will no longer be an option. Users do have a login for the website and this uses .NET, although I am unsure whether this can be passed thru to SQL reports.