Analytics Software

Hi,

I am trying to include an HTML link in a BI Publisher report. But I get the HTML Code, not the link.

I have put this in the Data Set SQL Query:

select id_constancia, rfc, apellido_paterno, apellido_materno, nombre, e_mail_empleado,
'a href="http://dbxserver.dbxprts.com:7778/pls/apex/f?p=134:1:::NO::P1_ID_CONSTANCIA:'||ID_CONSTANCIA||'">CITA</a ' as liga_cita
from geiq_constancias
where entregada = '0' and sust_rh = '0'

And I have included the field LIGA_CITA in the rtf template,

But I get this in the HTML output:

=======

Please clic on the link below to log into the system:

a href="http://dbxserver.dbxprts.com:7778/pls/apex/f?p=134:1:::NO::P1_ID_CONSTANCIA:1183">CITA</a

=========
(I removed the beginning and ending '<''>' to prevent the text to be shown as a link)

I have put the property "Make HTML output accessible" to TRUE in the report configuration, but nothing changes.

Does anyone know how to make this work?

Thanks.

Francisco