Profound Logic Forums

I noticed that if a chart is database driven that only one file can be referenced. I have a case where i want to chart a subfile where the name field is in one file and the value field is in another file like:

Select rppnam, sum(paamt)
from wdrpp join wdpap on .....

Is there a way to do this in a chart short of creating and populating a file on the fly?

I was able to find a way by binding fields to the data properties, like have a variable and for file and assign 'WDPAP, WDRPP' and make the join in the selection property. The only short coming is I am having an issue with use a case statement in the value property, but I am further than I was.

This issue has been resolved, the case statement didn't work because the field I was using was too small.

Glad you got it working. Another option is for you to use the Chart XML property. This property allows you to pass in XML fomatted data to populate your chart. For information on the format of the XML, refer to the Fusion Charts documentation at http://docs.fusioncharts.com/charts/