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?
Chart that Accesses Multiple Files
-
- New User
- Posts: 15
- Joined: Fri Feb 17, 2012 11:43 am
- First Name: Wesley
- Last Name: Winner
- Company Name: StoneRviver
- State / Province: Florida
- Country: United States
- Contact:
-
- New User
- Posts: 15
- Joined: Fri Feb 17, 2012 11:43 am
- First Name: Wesley
- Last Name: Winner
- Company Name: StoneRviver
- State / Province: Florida
- Country: United States
- Contact:
Re: Chart that Accesses Multiple Files
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.
-
- New User
- Posts: 15
- Joined: Fri Feb 17, 2012 11:43 am
- First Name: Wesley
- Last Name: Winner
- Company Name: StoneRviver
- State / Province: Florida
- Country: United States
- Contact:
Re: Chart that Accesses Multiple Files
This issue has been resolved, the case statement didn't work because the field I was using was too small.
- Brian
- Profound Logic Staff Member
- Posts: 286
- Joined: Thu Apr 14, 2011 10:23 am
- First Name: Brian
- Last Name: May
- Company Name: Profound Logic Software
- Contact:
Re: Chart that Accesses Multiple Files
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/
Who is online
Users browsing this forum: No registered users and 1 guest