Summary
Creating an Org Chart RTF Report -- Help!
Content
First, thank you in advance for your help.
I'm trying to create an Org Chart BI Publisher RTF (version 11.1.1.9) report and running into issues building dynamic columns.
My sample XML looks like this:
<?xml version='1.0'?>
<query numrows="24" queryname="LEVEL1DETAIL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">
<row rownumber="1">
<LEVEL1NAME><![CDATA[Manager 1]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[Mike]]></LEVEL2NAME>
</row>
<row rownumber="2">
<LEVEL1NAME><![CDATA[Manager 1]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[Tim]]></LEVEL2NAME>
</row>
<row rownumber="3">
<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[James]]></LEVEL2NAME>
</row>
<row rownumber="4">
<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[Chris]]></LEVEL2NAME>
</row>
<row rownumber="5">
<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[Rex]]></LEVEL2NAME>
</row>
<row rownumber="6">
<LEVEL1NAME><![CDATA[Manager 3]]></LEVEL1NAME>
<LEVEL2NAME><![CDATA[Jack]]></LEVEL2NAME>
</row>
</query>
I'm trying to Display the Level1Name values accross and the Level2Name values below.
| Manager 1 | Manager 2 | Manager 3 |
| Mike | Tim | James | Chris | Jack |
I can get the level1Names to print accross without a problem, but when adding the Level2Name row becomes an issue. I can't get the Level1Name to expand accross the level2names.
Is this possible?
Thank you!
Matt
