This discussion is archived
1 Reply Latest reply: Mar 26, 2013 1:11 AM by user13707551 RSS

Hyperlinks into pivot tables

975475 Newbie
Currently Being Moderated
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.

.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points