Hi All,
My users needs to be able to show data in a TDBGrid as well as viewing the data in a Chart. For that I was hoping to use the following setup:
TSQLQuery -> TDataSource -> TDBGrid
-> TDBChartSource -> TChart
The problem is that the Chart requires me to define a pseudo color column (for the pie series) and my users will not be able to ass such a thing in the query.
The only option I was able to come up with is to create a memory dataset and copy all the data to it and the column color or define my own chart source. I don't like either solution as it needs to copy a lot of data. Any other ideas?
Thanks,