Hi Gerard

There are a few query building tools on http://www.codeproject.com. I've used this one: http://www.codeproject.com/Articles/9211/SqlWhereBuilder-ASP-NET-Server-Control

Be careful to ensure the tool you use is preventing SQL Injection attacks and reusing query plans by using parameterized ad-hoc sql.

>Hi Craig.
>I have already evaluated SqlServer Reporting Services, and it does not seem to be suotable for our purposes. We need a Banded type report writer , which SSRS is not, and it proved almost impossible to get an Invocie type form printed(Has a Header, Detail, and Tax Summary on the trailer) This is the reason we selected Devexpress Report Writer, which on the reporting side is ideal, but leaves a lot to be desired on the Selection/Query side
>
>Regards,
>Gerard
>
>
>
>>You probably won't like my advice, but SQL Server Reporting Services does everything you need. Report designer and report criteria prompting for the user.
>>
>>>Hi Craig
>>>The user to pick criteria for an exisitng report or new report, so will be date ranges, customer ranges etc. May need to know about what tables are selected in order to do this....main idea is to build up a 'Select' statement with the correct queries required, so that a Dataset or Datatable is created, whcih will then be the source of a Report (user dos not need to get involved in). Prmarily Windoes based.
>>>
>>>Regards,
>>>Gerard