I have a grid which is populated from an SQL database, it has
a search box which when populated filters the results.
I am trying to output the filtered results in charts. I
currently have all the SQL data output in charts but would like to
make them dynamic to match what the grid is displaying.
Any help would be much appreciated
I have something that might help. I have a grid that I use a
CFC to populate, but then I also need to export the data to excel
and CSV. I do this by setting a session variable just before the
result get passed back from the CFC. This variable contains the
query that has provided the data, so i can then use it to create
the files I need for the export.