I am working on a web applicaiton project by using struts and I need find out for solutions to perform all types of queries even though all users are not familiar with sql statements at all. (They used to retrieve all types of data by using excel file and MS SQL Server somehow and it doesn’t work anymore for some reasons.) Since I am using different tools, I need to find a way of integrating this functionality to new project. The problem is that the all users do not know sql statement and still want to perform many different types of queries (relatively complex) and export data to excel files.
I appreciate any comments or information.