This is related to an earlier post today regarding ExecuteSQL. I have been reading quite a few articles but have a question about using the data retrieved from ExecuteSQL as data source for Charts. So far I have not found the information concerning charts and using the data values produced by ExecuteSQL.
What I am trying to do is to eliminate a need for quite a few Count calculations and Summary fields in a solution rewrite by replacing them with ExecuteSQL to produce the Counts and Summary data. I mainly need this to populate quite a few Charts. I am able to now achieve the correct counts & Summary values but when I try them in the Charts I am not able to get it to work as desired.
I am including a database file with just a few fields and several charts as examples.
Any assistance is appreciated.