I would like to create a web based query app. This app will hold about 5 million records in a database table. This table will then be available to our clients via a web interface. the client will then be able to filter and sort the table. Here are a list of features I am looking for initially.
1. Large table support (> 5 million records)
2. Web secure login
3. Web grid display
4. Sorting and Filtering on all fields.
5. Summary (aggregate functions)
6. Export to Excel on filtered/sorted results.
This application will need to support multiple data sets with different data structures. Each project will be accessed with a separate logon and maybe in a separate database.
I would like to be able to take advantage of some database tools like SQL Server Reporting Services or some ASP grid tools. This is mainly a grid type app.
I am not the best in defining these projects. Since this is a new app for us I would need some help defining the best techniques to use. We will also be enhancing the app going forward as we learn more.
I have attached some sample screens.
## Deliverables
Attached are sample screens.