hiding the username/password@db from the url while running 10g report

K1970

70 pts.

Tags:

Oracle 10g

Oracle 10g Database

Oracle Reports

Oracle Reports 10g

iam running reports from developer 10 g release 1 using web.show_document command ,my application serves multi users that means each user has his own database user and password , so adding the key method in the cgicmd.dat will not help like :

userlogin : destype = cache desformat=HTMLCSS userid=scott/tiger@orcl %

So, can I run report without showing the userid in URL?

Software/Hardware used:
developer 10g release1 , deployed on Oracle Application Server 10g

Asked: August 4, 2010 6:12 AM Last updated: December 24, 2010 2:25 PM

Answer Wiki

Last updated: August 4, 2010 2:12 PM GMT

carlosdl84,495 pts.
History
Contributors
- Ordered by most recent
- carlosdl84,495 pts.

Thanks. We'll let you know when a new response is added.

You could do it this way:

-Create a REPORT object in your form (object navigator)
-Call the RUN_REPORT_OBJECT built-in procedure
-Show the rerport using web.show_document

Here’s an example (assumming that the report object was already created):

<pre>declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT(‘REPORT1’);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘repsrv’);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML’);
<b>v_rep := RUN_REPORT_OBJECT(repid);</b>
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in (‘RUNNING’,’OPENING_REPORT’,’ENQUEUED’)
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = ‘FINISHED’ THEN
/*Display report*/
<b>WEB.Show_Document</b>(‘/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_’,-1)+1)|| ‘?destype=cache&desformat=pdf/html&server=’ || ‘repsrv’, ‘_blank’);
ELSE
message(‘Error…’);
END IF;
END;</pre>

Discuss This Question: 6 Replies

K1970 Aug 5, 2010 6:09 AM GMT

i have examined the solution you suggested but the followinf error message has been appeared: frm-41213 : unable to connect to report server repsrv

70 pointsBadges:

report
carlosdl Aug 5, 2010 1:27 PM GMT

In the example above, 'repsrv' is the name of the report server. You should change it to your report server's name.

84,495 pointsBadges:

report
K1970 Aug 15, 2010 6:24 AM GMT

thanks , the solution you gave me succeded but i don't want the result as pdf file i want as an ordinary previewer , i tried to replace the pdf/html with HTMCSS but it gave me the same pdf file, so how i can make it

70 pointsBadges:

report
carlosdl Sep 29, 2010 6:59 PM GMT
Sorry for late response. I overlooked this. Try setting the DESFORMAT parameter to the report object to HTML:
```
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML');
```
and don't include this parameter when showing the report:
```
WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?server=repsrv', '_blank');
```
This should generate an html report.
84,495 pointsBadges:
report
Nharisri Dec 24, 2010 9:45 AM GMT

Hi Sir, Try setting the DESFORMAT parameter to the report object to HTML: SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML‘);and don’t include this parameter when showing the report: WEB.Show_Document(’/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_',-1)+1)||’?server=repsrv’, ‘_blank’);This should generate an html report. Above one is working but how to send parameters to report? Report is generating blank. Thanks & Regards, Hari

10 pointsBadges:

report
carlosdl Dec 24, 2010 2:25 PM GMT
Hi Nharisri, To send parameters to the report you would have to create a parameter list, add the desired parameters to that list, and use the list when executing RUN_REPORT_OBJECT to call the report. Something like this:
```
DECLARE
	List_id ParamList; 
BEGIN
	List_id := Create_Parameter_List('input_params'); 
	Add_Parameter(List_id, 'CITY',TEXT_PARAMETER,'PARIS'); 
	Add_Parameter(List_id, 'CATEGORY',TEXT_PARAMETER,'EXPORTS');

...
...

	v_rep := RUN_REPORT_OBJECT(repid,List_id);

...

END
```
84,495 pointsBadges:
report