5 Replies Latest reply: Sep 10, 2013 8:40 AM by AlexAnd RSS

    Issue with BI Publisher

    Cri_Vasquez

      Hello People, we are developing a BI Publisher and we need to do the following.

       

      We've to display in the same row, the next row as a column. i.e

       

      PersonPerson

      rownumber=1

      EMPLID

      NAME

      rownumber=2

      EMPLID

      NAME

      rownumber=3

      EMPLID

      NAME

      rownumber=4

      EMPLID

      NAME

       

      is it possible?

      here is the XML that we're using.

       

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>
      <query numrows="10" queryname="CUS_ETI_REG_NAV" NS0:noNamespaceSchemaLocation="" xmlns:NS0="http://www.w3.org/2001/XMLSchema-instance">
        <row rownumber="1">
        <EMPLID>12345612-5</EMPLID>
        <NAME>Chuck Norris</NAME>
        </row>
        <row rownumber="2">
        <EMPLID>1-9</EMPLID>
        <NAME>Andrea Carrasco</NAME>
        </row>
        <row rownumber="3">
        <EMPLID>5-2</EMPLID>
        <NAME>Claudio Martinez</NAME>
        </row>
      </query>
      

      ---

       

       

      Thanks