July 11, 2006 at 6:56 am
Hi.
* SQLServer 2000
* W2KWS, W2K3 and Windows NT mix of clients.
* 60 local and remote users
We are looking for a reporting solution to roll out to our business users in remote satelite units reporting trend data and online transactional manufacturing levels against our primary DB.
Our aim is to provide pure web based reporting, dashboards, scheduled reporting, easy adhoc report building for non-technical staff and low cost of ownership.
Looking for product options and experiences with providing such a spec .... also require an option that does not involve 3rd party agents running on the client machines.
Any thoughts welcome ....
July 11, 2006 at 3:23 pm
Take a look at SQL Server 2005 Reporting Services. (I know you're running 2000, but the 2005 Reporting Service and its databases could be installed on a separate box, connecting to your 2000 server for report data.)
It provides pure web-based reporting, scheduled reporting with multiple delivery options (such as email), and an ad-hoc report-building component designed for non-technical users that runs in a web browser (no messy client installs).
The ad-hoc component is a feature of the 2005 edition, which is why I suggest that instead of the 2000 edition.
Both editions are pretty easy to build reports for... you can even import Access reports.
Depending on your security model, you may need to set up an ASP.Net application to sit between the Internet and your Reporting Services server, but that's not very difficult, and there are some solid examples with documentation on the Internet.
-Eddie
Eddie Wuerch
MCM: SQL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply