Looking for a Web/SQL reporting subsystem
-
Hi, I'm looking for a SQL-based reporting system with the following features for running against a SQL Server 2005 database. - SQL for each report is to be hand coded (i.e. NOT 'ad-hoc/drag-n-drop end user reporting') - Users will select parameters at run time - Output to browser (don't care about controlling hard-copy formatting) - Must be able to include complete T-SQL. - Ideally include support for transactional operations I wrote something very much like this in my last job, but would rather buy this time. Anyone used or even know of such a beast? I've scoured Google with no result. Everything I've found is either 'Build reports without knowing SQL' or 'use this toolkit to integrate a specific report into your application. Thanks, Max.
-
Hi, I'm looking for a SQL-based reporting system with the following features for running against a SQL Server 2005 database. - SQL for each report is to be hand coded (i.e. NOT 'ad-hoc/drag-n-drop end user reporting') - Users will select parameters at run time - Output to browser (don't care about controlling hard-copy formatting) - Must be able to include complete T-SQL. - Ideally include support for transactional operations I wrote something very much like this in my last job, but would rather buy this time. Anyone used or even know of such a beast? I've scoured Google with no result. Everything I've found is either 'Build reports without knowing SQL' or 'use this toolkit to integrate a specific report into your application. Thanks, Max.
It's called SQL Server Reporting Services. DevExpress also do an excellent reporting tool.
Never underestimate the power of human stupidity RAH