Sunday, February 12, 2012

Ad hoc reporting for sql server

Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

No comments:

Post a Comment