We have a large table of historical data (50 columns) and want users to view and compare data. Different users will want to compare different groups, and many will want to select which columns to show, etc.....
What is the best approach for this type of requirement:
1) Reporting software
2) Web app, that first allows selection of groups, and columns to display, then submit, then return what was selected.
3) A data grid with all data, then on client side - choose which columns, rows to show?
Any other ideas? Any recommended software?