We would like our analytics department to run the equivalent of CRM Advanced Finds on a web front-end. The data source for this connection is an MSSQL 2008 back-end. These employees have no SQL experience, so we want something very simple for them to choose columns to query against with values they choose (i.e. Customers that have a certain Net Worth or certain ZIP code).
We tried using EasyQuery: http://devtools.korzh.com/easyquery/asp-net/ but we're not entirely happy with it. It's not very responsive and we get weird, random crashes. Does anyone know of any other software out there that will allow for this functionality?
Thanks in advance!