Hi all,
I would like to create a PDF-Report with a Chart using Apex and the Template Builder plugin for Word.
My Select Statement, which I use as the Report Query (Shared Components) returns Data in the following way:
Date Description Value
---- ----- -----
01.01.2014 A 1.2
02.01.2014 A 1.3
03.01.2014 A 0.5
01.01.2014 B 0.3
02.01.2014 B 4.5
03.01.2014 B 4.8
The resulting XML, which APEX creates, is:
<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENT>
<DATE>10/08/2014</DATE>
<USER_NAME>ADMIN</USER_NAME>
<APP_ID>102</APP_ID>
<APP_NAME>Oracle APEX AppBuilder</APP_NAME>
<TITLE>Chart</TITLE>
<REGION ID="0">
<ROWSET>
<ROW>
<Date></Date>
<DESCRIPTION></DESCRIPTION>
<Value></Value>
</ROW>
</ROWSET>
</REGION>
</DOCUMENT>
What I would like to have is a Line-Graph with:
- Date on x-axis
- Value-span on y-axis
- for each Description-Type one Line
The names and numbers of the discription do vary alot (as well as the values as they are linked to the Description and date).
What i tried:
A lot, trying to make this work for 4 weeks on and off.
Tried to modify the Graph-XML in Word, change the SQL-Statement itself, pivot the SQL-Result to get the Descriptions as Columns and ofcourse a lot of googling.
Please let me know if you have any advice.
Thanks in advance,
Thomas
Oracle DB: 11g
ApEx Version: 4.2.5.00.08
Latest Oracle BI Template Builder Plugin for Word