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

    Hyperlinks into pivot tables


      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>

      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.