I am building an internal company website for the first time. I have a reports page that will have 6 reports on it. I'm trying to determine the best way to display those.
Each report is based on a SQL Server View.
I tried using a flexgrid which connects to the database just fine. I'm able to modify the connection to the database so that depending on which report is selected on a ListView the connection string reflects the correct query.
The problem is that each report has some similar and some different fields and I've been unable to come up with a dynamic way to change the flexgrid accordingly.
Any idea will be tested but I don't want to display 6 different flexgrids as the user will only look at 1 report at a time.
Thank you
