I have a situation where I would like to run a report from the information contained in a GridView. The information comes from a dynamically generated SQL statement that is then created in a view. I need to be able to report the same information that is in the GridView when the user clicks a button. The would be simple to do if I create a dataset from the view but I can't add fields in the designing of the report because the report fields could change. Therefore I need to able to create the report dynamically, either from the SQL statement or from C# code.
Any suggestions or how to do this?
I am presently using Crystal Reports, but JavaScript, AJAX, HTML, or any other way to report the GridView information would be fine.
Start Free Trial