I'm trying to make a report with its chart, I have prepared web services functions to give the data to the report and the chart (one function for each one).
The problems is that I don't know exactly how to make the chart. I'm using the word and the plugin for designing the report, but I don't know how to set inside the chart the values properly.
I need to show a percentage in the Y axis, and group of values obtained from each location (grouped by hour) on the X axis, so that I get group of bars fro each time the sample is taken.
|_________|__________|__________|_________|_________ Sample moments (with their group of bars for each moment, and each bar representing a location)
How can I make this?? When I try to make the chart I can give the three values (percentage,moment and all the bars for locations), and it requires to give an aggregation...
Can anyone help me please?? where can I get a good tutorial or documentation about how to make charts or reports with rtf templates?? I cant found an official document explaining it.
Thanks a lot
For displaying percentages, take a look at this blog post: https://blogs.oracle.com/xmlpublisher/entry/working_the_chart_percentages
Take a look at the demo library and look for charts: http://www.oracle.com/technetwork/middleware/bi-publisher/learnmore/demo-library-toc-173301.html
Take a look at this for some other charting posts: https://blogs.oracle.com/xmlpublisher/category/Oracle/Templates/RTF/Charting
This will require modification to the chart code unless you can bring in the values via modification to the sql.
If you want to make modifications to the chart code, make sure you make a copy of the RTF template and then change the chart code for Label as:
<Label><xsl:value-of select="substring(current-group()/DATE,12,5)" /></Label>
You make the change in the Advanced Tab of the Chart in Word 2010 or look for the code under Size in previous versions... Look for the tag <Label>