2. How to use the Fusion Charts component in an OutSystems Application

Open your application in Service Studio, click Add/Remove References and Import the public FusionCharts web block;.

Use the FusionCharts Web Block in your web screen and pass the correct parameters to display the chart (see the parameters used in the sample application at http://localhost/FusionCharts/ for examples)

3. How to generate the chart XML data based on the information in the database

The fusion charts XML is normally very simple, so generating the XML depending on the data you have on the database can be done by simply doing some string manipulation. To get detailed documentation for each chart XML structure and options see the following resources:

Attached you have a sample eSpace FusionCharts_Sample.oml (click here to download it) that is a good example of the generation of the XML for a Multi Series 3D column chart. The goal is to show the Expenses of a household by Category from 2005 to 2010. To generate this chart XML, we use the data stored in two entities - YEARLY_EXPENSE and EXPENSE_TYPE.

Open the attached FusionCharts_Sample.oml in Service Studio to see how the chart XML is created in the HomePage preparation. Publish this eSpace in your OutSystems installation to see it working (sample data is automatically created). See below a screenshot of the action that generates the chart XML.

Naturally, the logic needed to generate each Chart will always depend on the type of chart you want to create and the logic needed to gather the necessary data. Nevertheless, the core principal is always the same - access and iterate your OutSystems Entities while you generate the chart XML.

In more complex situations you can also use the OutSystems XML component for XML manipulation.

4. Where to find Fusion Charts detailed documentation

To get detailed documentation for each chart XML structure and options see the following resources:

I found out yesterday that the Charting Services Component is using a paid version instead of the free version. On the example page, remove "FCF_" from the chart type and then click redraw chart to see the updates. I did notice that the charts included in FusionWidgets and PowerCharts are NOT included as the paid versions (i.e. Candlestick, Gantt Chart).

I have tried "MSCombi3d.swf" in the FusionCharts Espace which is a predecessor for the ChartingServicesCore. It includes a sample screen for testing. I'm not getting it to work here either (we have access to this file).