OTN Discussion Forums : PROBLEM WITH XML PUBLISHER AND GRAPH ...

Sharky

Posts: 86
Registered: 09/14/06

PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Jun 26, 2008 9:56 AM

Hi

All you XML Gurus here. I have a problem, When i create a report in XML Publisher desktop i can see a graph im putting into the report on preview and works fine. But when i upload the report as a rtf file into Oracle applications i can see everything else the table logo and stuff .. But just not the Graph Itself when run on the concurrant manager....

Problem number 2

Is there a way that i can use XML Desktop and create a line graph with 2 lines rather than 1 plotting

here is my xml for graph i have made with one line

chart:
<Graph>
<Title text="" visible="true" horizontalAlignment="CENTER"/>
<LocalGridData colCount="{count(.//SELF_OTHERS)}" rowCount="1">
<RowLabels><Label></Label></RowLabels>
<ColLabels>
<xsl:for-each select=".//SELF_OTHERS"> <Label><xsl:value-of select="BEHAVIOUR"/></Label>
</xsl:for-each>
</ColLabels>
<DataValues>
<RowData>
<xsl:for-each select=".//SELF_OTHERS"> <Cell><xsl:value-of select="SCORE"/></Cell>
</xsl:for-each> </RowData>
</DataValues>
</LocalGridData>
</Graph>

All help would be much appreciated to my 2 problems....

Thanks

Sha

Sharky

Posts: 86
Registered: 09/14/06

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Jun 26, 2008 9:59 AM

in response to: Sharky

Reply

Sorry i forgot to mention this is my table structure

Participent Type - MYSELF , SOMEONE
Score
Behaviour

So i need a graph where i can have the Behavior along the bottom then show 2 lines,one showing the scores for MYSELF and the other showing scores for SOMEONE.

Cheers

Sha

Message was edited by:
Sharky

Vetsrini

Posts: 2,615
Registered: 07/24/06

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Jun 26, 2008 6:10 PM

in response to: Sharky

Reply

for graphs and chart xserver has to setup,

please seee documentation for Xserver in linux EBS server

Sharky

Posts: 86
Registered: 09/14/06

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Jun 27, 2008 5:36 AM

in response to: Vetsrini

Reply

Thanks i have also resolved the graph problem here is the xml - I was wondering does anyone know how to Make the font bigger for the Legend, and x and y axis labels....

chart:
<Graph graphType="LINE_VERT_ABS" dgraphicAntialiasing="true" textAntialiasing="true">
<Title text="COMPARISION OF SELF AND THE AVERAGE OF ALL OTHER RESPONDENTS (Others)" visible="true" horizontalAlignment="CENTER"/>
<Y1Title text="Behaviour Overall Score out of 30" visible="true"/>
<O1Title text="High Performance Behaviours" visible="true"/>
<LegendArea automaticPlacement="AP_NEVER" position="LAP_SIDE"/>
<MarkerText visible="true" markerTextPlace="MTP_CENTER"/>
<O1MajorTick visible="true"/>
<X1MajorTick visible="true"/>
<Y1MajorTick visible="true"/>
<Y2MajorTick visible="true"/>
<SeriesItems>
<GraphFont size="18" bold="true"/>
<Series id="0" color="#9900" lineStyle="LS_DASH"/>
<Series id="1" color="#3366ff" lineStyle="LS_SOLID"/>
</SeriesItems>
<LocalGridData colCount="{count(xdoxslt:group(.//SELF_OTHERS, 'BEHAVIOUR'))}" rowCount="2">
<RowLabels>
<Label>Self</Label>
<Label>Others</Label>
</RowLabels>
<ColLabels>
<xsl:for-each-group select=".//SELF_OTHERS" group-by="BEHAVIOUR">
<xsl:sort select="BEHAVIOUR"/>
<Label><xsl:value-of select="BEHAVIOUR"/></Label>
</xsl:for-each-group>
</ColLabels>
<DataValues>
<RowData>
<xsl:for-each-group select=".//SELF_OTHERS" group-by="BEHAVIOUR">
<xsl:sort select="BEHAVIOUR"/>
<Cell><xsl:value-of select="SELF"/></Cell>
</xsl:for-each-group> </RowData>
<RowData>
<xsl:for-each-group select=".//SELF_OTHERS" group-by="BEHAVIOUR">
<xsl:sort select="BEHAVIOUR"/>
<Cell><xsl:value-of select="OTHER"/></Cell>
</xsl:for-each-group> </RowData>
</DataValues>
</LocalGridData>
</Graph>

lokeshgandhi

Posts: 3
Registered: 08/20/08

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Aug 20, 2008 5:50 AM

in response to: Sharky

Reply

Hi Sharky,

We have a similar requirement to display 3 different linear graphs in a single graph. Could you please give us the XML format used for the graph.

Cheers.

lokeshgandhi

Posts: 3
Registered: 08/20/08

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Aug 20, 2008 11:05 PM

in response to: Sharky

Reply

Hey,

We have a similar requirement, but could you please give us the XML format for creating the 2 lines in a single Line Graph.

Cheers

Tim Dexter

Posts: 2,268
Registered: 01/10/01

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Aug 21, 2008 1:07 PM

in response to: lokeshgandhi

Reply

Hi All

Will post solution tomorrow or Monday on blog. Heres the chart XML for now.

chart:
<Graph graphType="LINE_VERT_ABS"><LegendArea visible="true" />
<LocalGridData colCount="{count(xdoxslt:group(.//SALE, 'YEAR'))}" rowCount="3">
<RowLabels>
<Label>SOFTWARE</Label>
<Label>HARDWARE</Label>
<Label>SERVICES</Label>
</RowLabels>
<ColLabels>
<xsl:for-each-group select=".//SALE" group-by="YEAR" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<Label>
<xsl:value-of select="current-group()/YEAR" />
</Label>
</xsl:for-each-group>
</ColLabels>
<DataValues>
<RowData>
<xsl:for-each-group select=".//SALE" group-by="YEAR" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<Cell>
<xsl:value-of select="sum(current-group()/SOFTWARE)" />
</Cell>
</xsl:for-each-group>
</RowData>
<RowData>
<xsl:for-each-group select=".//SALE" group-by="YEAR" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<Cell>
<xsl:value-of select="sum(current-group()/HARDWARE)" />
</Cell>
</xsl:for-each-group>
</RowData>
<RowData>
<xsl:for-each-group select=".//SALE" group-by="YEAR" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<Cell>
<xsl:value-of select="sum(current-group()/SERVICES)" />
</Cell>
</xsl:for-each-group>
</RowData>
</DataValues>
</LocalGridData>
</Graph>

with the following data
<?xml version="1.0" encoding="UTF-8"?>
<SALES>
<SALE>
<YEAR>2006</YEAR>
<SOFTWARE>1200</SOFTWARE>
<HARDWARE>850</HARDWARE>
<SERVICES>2000</SERVICES>
</SALE>
<SALE>
<YEAR>2007</YEAR>
<SOFTWARE>1000</SOFTWARE>
<HARDWARE>800</HARDWARE>
<SERVICES>1100</SERVICES>
</SALE>
<SALE>
<YEAR>2008</YEAR>
<SOFTWARE>900</SOFTWARE>
<HARDWARE>1200</HARDWARE>
<SERVICES>1500</SERVICES>
</SALE>
</SALES>

The latest Template Builder makes this a cinch!

Regards

Tim

http://blogs.oracle.com/xmlpublisher

Mike Mac

Posts: 161
Registered: 03/07/07

Latest Template Builder - Where is this available?
Posted: Aug 21, 2008 11:07 PM

in response to: Tim Dexter

Reply

Hi Tim
You mention "The latest Template Builder makes this a cinch!"

Where do we get this long awaited Template Builder?

Thanks

Mike

Vetsrini

Posts: 2,615
Registered: 07/24/06

Re: Latest Template Builder - Where is this available?
Posted: Sep 10, 2008 10:42 AM

in response to: Mike Mac

Reply

http://www.oracle.com/technology/software/products/publishing/index.html

user529990

Posts: 39
Registered: 09/11/06

Re: Latest Template Builder - Where is this available?
Posted: Sep 16, 2008 3:58 AM

in response to: Vetsrini

Reply

Hi Tim,
I have also similar requirement where instead of 3 lines I have to display Horizontal Bar Chart. This is happening fine.
But I want the ROWLABELS which appear in the right side ,I want it at the bottom of the report so that
I get a bigger length of the Horizontal BAR.
Will it be possible ?If so, I would be happy to receive the XSL Code as I am weak in this part of XML Publisher.

Thanks In Advance,
Krishna

Vetsrini

Posts: 2,615
Registered: 07/24/06

Re: Latest Template Builder - Where is this available?
Posted: Sep 16, 2008 6:56 AM

in response to: user529990

Reply

Hi Krishna

<LegendArea visible="true" automaticPlacement="AP_NEVER" position "LAP_BOTTOM"/>

position can have following value (LAP_TOP | LAP_BOTTOM | LAP_RIGHT | LAP_LEFT)

user529990

Posts: 39
Registered: 09/11/06

Re: Latest Template Builder - Where is this available?
Posted: Sep 17, 2008 12:07 AM

in response to: Vetsrini

Reply

Hi Srini,
Thanks for your response. Its working with your code.

Thanks,
krishna

oraDBA2

Posts: 1,078
Registered: 05/09/07

Re: PROBLEM WITH XML PUBLISHER AND GRAPH NOT DISPLAYING IN ORACLE APPS
Posted: Oct 8, 2009 11:55 PM

in response to: Sharky

Reply

Thanks i have also resolved the graph problem here is the xml

Hi, we have an issue with Charts in XML reports. When we move the xml report to Oracle Application and run that, everything is working fine, but Charts in Report is not appearing..just blank...

could you please guide me, how to resolve this issue.

Oracle Support people told that, you have DISPLAY Server problem.

If there is problem with DISPLAY, we would not be able to run PDF reports or XML in PDF Or EXcel reports right? but these are working fine.

Still Charts in XML Report is not showing... please guide me in this regard.....