Cant see the Woods for the Trees

PSTree1.jpg

Another collaborative solution today. Mikhail on the PeopleSoft reporting team had a tough little problem. Those of you that know PeopleSoft, will know that its full of 'trees'. A very powerful way of building hierarchies for all types of application e.g. financial accounts. However, lots of his customers want to be able to print the tree structures out.

Publisher is embedded inside PeopleTools so its just a case of writing the PSQuery and layut template right? Right, just need a little bit of a trick.

Mikhail was after something like the structure to the right. Notice the icons to denote leaf or node(folder) and the indenting to show the tree structure.

Thankfully his data contained everything needed to get the order and the indenting level.

   <NODE>
    <ID>00001</ID>
    <DESCR>Corporate Headquarters</DESCR>
    <Level>Corporate</Level>
    <Type>N</Type>
    <NodeIndent>1</NodeIndent>
    <LineMap />
   </NODE>
   <NODE>
    <ID>8200</ID>
    <DESCR>Albright</DESCR>
    <Level></Level>
    <Type>L</Type>
    <NodeIndent>2</NodeIndent>
    <LineMap>C</LineMap>
   </NODE>
   <NODE>
    <ID>8300</ID>
    <DESCR>Vincent</DESCR>
    <Level></Level>
    <Type>L</Type>
    <NodeIndent>2</NodeIndent>
    <LineMap>C</LineMap>
   </NODE>

To get the tree to render the template is pretty straightforward, just needed some tricksy hobbitises magic and some time.

PSTree2.jpg

I have reduced the width of the first cell to get the graphic to fit. You need to make it wide enough to fit the possible indenting you might need. The fields contain the following:

PSTree3.jpg

The higlighted field has the code to override the default start-indent attribute. Its just a calculation based on the NodeIndent value multiplied by a constant. You can mess with that to you hearts content. Notice the if@inlines for the leaf/node images, the @inlines prevents BIP from dropping in a new line character.

Its probably not a widely needed feature but I thought it was worth sharing, if nothing else, the rendered tree looks cool. As I mentioned, a collaborative effort, thanks again to Klaus and Hok Min for the solution.

Comments:

What's more, thanks to the growing competition in this sector, the pricing has also become very economical and affordable, which has bridged the gap between a home made product and a branded one as far as the cost factor is concerned.

Posted by Bryon Black Jeans Jacket on July 15, 2010 at 07:12 PM MDT #

It looks great. Now as you promised before we would like to see a Org Chart in BIP

Posted by dpal on July 23, 2010 at 01:13 AM MDT #

Hi Tim, SUB:Excel templates in BI Publisher We have a requirement wherein we need to display a column with variable number of rows into a single row (several columns) in Excel template. I didnt find enough syntaxes other than XDO_?element_name? and XDO_GROUP_?group_name? fpr excel templates in BI Publisher. Do you have syntax for implementing for-each@cell:ROW end for-each as in word template in Excel template. Thanks, Swathi

Posted by Swathi on July 27, 2010 at 08:13 AM MDT #

Hi Tim, SUB:Excel templates in BI Publisher We have a requirement wherein we need to display a column with variable number of rows into a single row (several columns) in Excel template. I didnt find enough syntaxes other than XDO_?element_name? and XDO_GROUP_?group_name? fpr excel templates in BI Publisher. Do you have syntax for implementing for-each@cell:ROW end for-each as in word template in Excel template. Thanks, Swathi

Posted by Swathi on July 27, 2010 at 08:13 AM MDT #

Verizon is getting the iPhone...AT&T is going to make life miserable for its customers....

Posted by Darin Takata on October 15, 2010 at 01:56 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today