1 Reply Latest reply: Mar 26, 2013 3:11 AM by user13707551 RSS

    Hyperlinks into pivot tables

    975475
      Hi!

      I'm coding a report using rtf templates. I need to add a hyperlink into a field of a pivot table in order to link my report to another. I followed this tutorial http://bipconsulting.blogspot.com.es/2010/02/drill-down-to-detail-or-another-report.html but when I try to add the hyper link into a field of a pivot table Bi publisher can't resolve the {} contents of the url.

      Here is a piece of my xml:

      <?xml version="1.0" encoding="UTF-8"?>
      <!--Generated by Oracle BI Publisher 11.1.1.6.2-->
      <DATA_DS><A_FECHADESDE></A_FECHADESDE><A_FECHAHASTA></A_FECHAHASTA><A_MESES>3</A_MESES>
      <G_1>
      <AREA>MI_AREA</AREA>
      <PRI>Alta</PRI>
      <ESTADO>PENDIENTE&gt;3meses</ESTADO>
      <NUM_REG>1</NUM_REG>
      <USUARIO>oficina1</USUARIO>
      <FD/>
      <FH/>
      <CODPRI>134</CODPRI>
      <PCJ>1.0</PCJ>
      </G_1>
      <G_1>
      ...

      If I use this: a.com{AREA} as a hyperlink I obtain a.com in the report. But if I use this: a.com{DATA_DS/G_1/AREA} I get a.comMI_AREA for every row.
      My pivot table looks like this:

      | estado
      _____________________

      | numReg | sum |
      _____________________
      area | | |

      Any thoughts?

      Thx in advance.

      .