AnsweredAssumed Answered

Charts using Data from ExecuteSQL

Question asked by mikeo'neil on Oct 19, 2017
Latest reply on Oct 19, 2017 by mikeo'neil

Hi Folks,


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.