Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drill Down Report browser URL

2715131Jul 17 2014

While calling a report (assume ABC.rdf) from parameter form (Forms 10G) using something like:

RP2RRO.RP2RRO_RUN_PRODUCT, when this report opens up in browser, I see URL somewhat like:

http://192.168.-.-/reports/rwservlet/getjobid27190?server=rep_erp_oracleas2

Then I am using the format trigger of an object on this report to call another report (assume DEF.rdf, Drilldown) using something like:

srw.set_hyperlink('/reports/rwservlet/getjobid?&report=DEF.rdf&

DEPT='|| :DEPT_CODE||'&COMP='||:COMP_CODE ||'&CS='||:CS_CODE||'& CUR_LOC='||:CUR_LOC||'&cmdkey=user1&envid=HR&destype=cache&desformat=pdf&paramform=no');

When this report runs in browser, I see URL somewhat like:

http://192.168.-.-/reports/rwservlet?&report=DEF.rdf&%0ADEPT=105&COMP=01&CS=1&%20CUR_LOC=NO&cmdkey=user1&envid=HRMSENV&destype=cache&desformat=pdf&paramform=no


I want the URL of second report similar to that of the first one to any extent, be it cleared at all, shortened, or at least parameter values are hidden. Is there a way I can do that? For example, getjobid was generated when first report was called, and was not generated when the drill-down report opened in browser.

Please suggest if you know any solution on this.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2014
Added on Jul 17 2014
0 comments
862 views