>>
>>You can do it with SQL Server Reporting Services in SQL 2005.
>
>William,
>
>Are you saying you can create and modify report at run time? Is it a separate engine installable in user's pc?

Depending on the users rights on the reporting services site, the user can either just use created reports or the user can build custom reports using predefined datasets. It's really cool.

SQL Server Reporting Services runs on a web site - all users need is a browser.