Solved

Oracle Reports 11g Drill Down Problem

Posted on 2010-11-26
2
1,386 Views
Last Modified: 2013-12-06
Hi,
After I did upgrade from oracle 6i to 11g, all drill down buttons were turned into links. And Oracle Support showed me how to pass user/password@connect as parameters to subreport with password information displayed on url. This is not acceptable, and I am wondering if you know how to drill down without display user's password in url.
Thanks a lot,
Luchuan
0
Comment
Question by:luchuanc
2 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 34383758
Oracle has provieded serveral methods to resolve this problem, one of these solution is to define keymapping in CGICMD.DAT file.  In Reports services 11g this file is located at following location

$DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/reports/configuration/cgicmd.dat



More details here:

http://exploreoracle.com/2010/06/09/hide-username-and-password-while-calling-oracle-reports/
0
 

Author Closing Comment

by:luchuanc
ID: 34500811
Hi schwertner:
Sorry, the project is on hold, so I will revisit this later
thanks for youir help,
Luchuan
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now