Sunday, January 27, 2013

XML Publisher - Display Values Dynamically

In this section , i will explain how to display values dynamically column wise,

First Query your requirements and then consider that you have many organizations and more will be added later on stages. So you cannot go manually touch your design and add up the extra columns , this will hike up your work process. You can neglect it by following a simple method in BI Publisher.

First Draw up your table using the Wizard

Name
Sample
Number
Description
F NAME
SAMPLE
Number
DESCRIPTION  E
Then insert a column to the right and insert the organization field in between the for loop

Name
Sample
Number
Description
F  OU  E
NAME
SAMPLE
Number
DESCRIPTION
F SOMEFIELD E E
Now double click on For loop (OU) and edit your xml from normal group to  Group_name;Column_name
Eg: <? for-each-grp:G_ORG;ORG ?>
And End it as 
<?end for-each-grp?>

After altering your xml script , you will finally get the output of OU column parallel format dynamically. 

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. I like this post,And I guess that they having fun to read this post,they shall take a good site to make a information,thanks for sharing it to me. Danilo

    ReplyDelete