Charts

[Paul]

I would like to create a multi-series chart in a ProfoundUI screen, for example, display sales and revenue by month.

I have looked at the Fusion documentation, and created a dummy XML file from their example and placed this in /profoundui/userdata, then pointed "chart url" to this file. I have also copy/pasted this into the "chart xml" property, but neither are showing any results.

I'd appreciate any suggestions ....

Cheers,

Paul

[Scott Klement]

Ahh, my mistake was that I forgot to select a multi-series chart. (I haven't done charts in awhile and am a little bit rusty!)

Perhaps you made the same mistake? There are differnet chart types for regular and multi-series charts. To get started, take a look at the profoundui/proddata/charts subdirectory of your IFS. You should see something like this:

Code: Select all

WRKLNK '/www/profoundui/htdocs/profoundui/proddata/charts/*'

The chart names that begin with "MS" are multi-series charts.

MSCharts.png (12.67 KiB) Viewed 909 times

When you set up your chart properties, you need to use the filename of a multi-series chart, but without the .swf extension. To do that, you need to first select "Other" as your chart type:

SelectOther.png (18.14 KiB) Viewed 908 times

Now that you've done that, you can type the name of the file (without the .swf) of the chart type you wish to use:

TypeChartName.png (15.33 KiB) Viewed 908 times

So now that I've selected a multi-series chart, I can set my chart URL and it shoudl work.

Or better yet, for a dynamic chart, use the "chart xml" property, and bind it to a large field. Then, build the XML string in that field and send it from your RPG program -- that makes it easier to set up all the values from your databases...

[Paul]

Nice one Scott, works a treat! I think you're right, building the xml as a bound variable in the RPG is the best option.

Thanks,

Paul

[kfritz]

Scott,

Thanks, for this post - very interesting. Only a small question: Beginning with V6R1 it's possible to define strings up to 16 MB. How can i accomplish this, when the input length of the bound field allows max. 99999 characters? (means for a XXXXL xml/json string or other purposes)

Thanks and take care.
Karl

[Scott Klement]

Thanks, for this post - very interesting. Only a small question: Beginning with V6R1 it's possible to define strings up to 16 MB. How can i accomplish this, when the input length of the bound field allows max. 99999 characters? (means for a XXXXL xml/json string or other purposes)

While RPG allows fields as large as 16mb, DDS does not. A bound field is creating a field for DDS (not RPG directly.) So we must abide by DDSs rules.