Re: Creating a PDF from web with reports

be aware that you are publishing your oracle username and password to the world by including it in the URL

check out the reports server config file for a way to hide the login info

also, look into integrating report server security with portal security (if you are on 9iAS release 2 using portal) -- otherwise, you may have to design an architecture to register the report request in a database table before calling oracle reports, then have a startup trigger in the report that checks if the report request is (still) valid

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048


<victoragus_at_yahoo.es> wrote in message
news:8e3f58b1.0310280137.4a7d6f21_at_posting.google.com...


> Hiya,


> I found an answer for myself, due to nobody's told me a solution.

> This is what I did: do another query to pdf, via javascript.

>

>   function abrirPDF(idioma, any, mes, centro)

>   {

>     var URL;

>     Trim(idioma);

>     Trim(any);

>     Trim(mes);

>     Trim(centro);

>

>     URL =

"consumo_x_linea.rdf&userid=scott/tiger_at_test&desformat=pdf&destype=cache&PID
IOMA="+idioma+"&PANY="+any+"&PMES="+mes+"&PCENTRO="+centro;


>     window.open(URL,'Consumo por


>

linea','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbar
s=no,titlebar=yes,resizable=yes,width=800,height=600');


>   }

>

> but you need to have this vars catched:


>

> <!-- RECEPCION DE PARAMETROS -->

> <jsp:directive.page import="java.lang.*" />

>

> <%! private String strIdioma = "CAS"; %>

> <%! private String strCentro = ""; %>

> <%! private String strNomCentro = ""; %>

> <%! private String strMes = ""; %>

> <%! private String strAnyo = ""; %>

>

>

> <!-- y recuperamos los valores -->

> <rw:getValue id="strIdioma" src="PIDIOMA"/>

> <rw:getValue id="strCentro" src="PCENTRO"/>

> <rw:getValue id="strNomCentro" src="PNOMCEN"/>

> <rw:getValue id="strMes" src="PMES"/>

> <rw:getValue id="strAnyo" src="PANY"/>

>

>

>

> and, where you desire to do the calling, do this call to a javascript

> function:

>

>       <p align="right">

>          <a href="javascript:abrirPDF('<%= strIdioma %>','<%= strAnyo

> %>','<%= strMes %>','<%= strCentro %>')"><img border="0"

> src="images/dcib008b.gif" width="20" height="20" alt="Imprimir

> Informe"></a>

>       </p>