>>>Hi,
>>>
>>>a client is wanting to create their own reports from a SQL Server database (yeah right!). They must be able to export the results to Excel.
>>>
>>>I am familiar with Stonefield Query and SQL Server Reporting Services (I don't think they will be tech savvy enough to use SSRS). Are there any other tools out there that will be easy enough for an end user to use to query a database?
>>
>>I would take a look at Report Builder. The early versions were not very good, but the more recent versions are better. I did some training a while back on both SSRS and Report Builder for the Federal Reserve, and they have power/business users creating plenty of report content with Report Builder. The export to Excel is good.
>
>Thanks Kevin,
>
>I don't have much confidence in the client having users with the ability necessary to build a report on their own, but I'll give it a try and see if they can handle it. Report Builder works on top of SSRS so they will need to install and configure SSRS on their database server, right?

Yes, Report Builder works on top of the SSRS engine - it's basically about 80% of SSRS in Visual Studio, but with a bit more of an Office look and feel to it.

For any user to build reports, they have to have some basic understanding of tabular and matrix output (and grouping, if applicable), even if it's expressed in non-technical terms.