OraFAQ Forum: Business Intelligence

Home » Fusion Middleware & Colab Suite » Business Intelligence » Xml Publisher

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Xml Publisher [message #204344]

Mon, 20 November 2006 04:14

orafan2003
Messages: 122
Registered: February 2006

Senior Member

Hi,
I am new to XML publisher.
I want to insert a graph in the MS word document using "Template Builder" option.
I inserted the graph with employee name in the X-axis and salary in the Y-axis.
The problem is that when I preview, I am only able to see the bar graph for 1 employee. What about the other employees?
This is the code for the graph generated by Word.

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

How can I get the details for all employees?
Also is there any property like drill down ie clicking on the bar, passing a parameter should open up another graph?
Kindly guide me

Report message to a moderator