Chart that Accesses Multiple Files

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
winnerwes
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:

Chart that Accesses Multiple Files

Post by winnerwes »

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?
winnerwes
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

Post by winnerwes »

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.
winnerwes
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

Post by winnerwes »

This issue has been resolved, the case statement didn't work because the field I was using was too small.
User avatar
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

Post by Brian »

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/
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest