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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer