I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.
View 6 RepliesI migrated the report from Developer 2000. This report has the drill down report with the following command.
procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;
After Migration into Oracle Application Server 10g release 2 , I changed the code as following:
function U_1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem
When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.
I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".
Can we hide the username/password@dbname from hyperlink html, so that when ever we change our user password we should not change in each report calling from another report
View 1 Replies View RelatedI already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:
sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1
So when i run this show me the message:
File 'c: este.rdf=%' not found.
It's showing a '=' sign
I have report consists of five fields, the user can be fill three fields only or fill four fields. How can remove blank spaces between fields if users select a less then 5 fields.
View 2 Replies View RelatedI am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies View Relatedi'm generating some document to pdf and sending them to a company. When they print them out the images in the pdf aren't very good, although they look ok in the pdf. i think it's a gif format at the minute.
what is the best image format for the best quality?
i have a problem where i want to import a document of type.doc which contains a 15 pages of text and a log into the oracle 10g report.
View 9 Replies View RelatedWhen running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies View RelatedI want to hide one frame and display the other depending on the parameter value . How could i make that ?
View 1 Replies View RelatedWhen I give the report Full path like 'C:FolderNameCurrency2.rdf. Successfully report run.
after changing the registry path like Reports_Path='C:FolderName'
When I click a button to run the report,I received the following errors.
declare
v_report_nameVARCHAR2(100) := 'Currency2.rdf';
begin
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name,'_blank');
end ;
"
REP-110: File Currency2.rdf cannot be opened.
REP-1070: An error occurred while opening or saving a document.
REP-0110: File Currency2.rdf cannot be opened."
i makes formula on the column in oracle forms such as
column it's name
column1 and this column return value from another column column2
and used the
calculation mode = formula
formula = (:column1 + :column2)
the formula will be
(:column1 + :column2)
and this formula will appear in column3 how can show column3 in oracle report ?
In Reports 11g when user move mouse to hyperlink then I want to show user help message Like 'Please Click here for more detailed Information'
Same as Forms Tool tip property.
We are going to provide a form where emmployees can see and download their payslips in PDF format.
I would like to have that PDF password protected for both access and edit the PDF.
We are using Reports 6i.
I have a date column , and i want to show the date in 'DD/MM/YYYY' format for eg days with 2 digit or comming properly but when it comes to single digit the 0 is not comming for example 4/11/2012 should come as 04/11/2012 like 16/11/2012 , i even did the conversion like to_char(rh_dt,'DD/MM/RRRR').
View 4 Replies View RelatedWhen i create report in master detail. When detail record end on the page, the second record show on same page. Problem is that detail show on other page. I want that if record is completed on that page then ok. Otherwise it show on next page.
View 3 Replies View RelatedI want to show 1 record per page in matrix report. I set Main section orientation as landscape and width is 14. but it show multiple records on single page.
View 2 Replies View RelatedIs it possible to generate .pdf file with password protection.
View 2 Replies View RelatedHow user can change password in oracle discoverer desktop ?
View 1 Replies View RelatedI am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.
View 5 Replies View RelatedI want to create pdf file of a report with password protection for security reason with. eg. Employee A is logged to run rep1. The pdf file created to his desk with his userid & password.
View 1 Replies View Relatedi want to create password protected pdf report using bursting in oracle for each new pdf i want new password..but password should be dyanamic for each pdf.
View 1 Replies View Relatedam trying to use secure call to reports from forms using the frmrwinteg.jar javabean.
when i set the implementation class of the javabean area i still have the error FRM-13008 can't find javabean with name..,but i ignore it as i read at the whitepaper downloaded from OTN. and follow all instructions add to java directory,, add to formsweb,, add parameter to basejini.htm
each time i call the report i have been asked to connect and when i run the form my username and password are written to the consol and i still can see them at the html code when call parameter form, my code is
DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='http://office_server:8889/reports/rwservlet?server=repserver10&report=d:mm-J.JSP
&desformat=htmlcss&destype=CACHE¶mform=yes&userid=';
set_custom_property('block3.userid_bean',1,'WRITE_LOGOUTPUT','true');
[code]...
and this is what is written to the consol
FrmReportsInteg1: Debugging true
FrmReportsInteg1: Adding new userid string "xx/xx@xxxxx"
FrmReportsInteg1: ADD_REPORTS_CONNECT: xx/xx@xxxxx
FrmReportsInteg1: Setting cookie path to /reports/TEST/
[code]/....
i DON'T KNOW WHERE IS THE ERROR THAT MAKE THIS NOT WORK.
i want to hide/Show tab according to application user.i want to display tab abc if application user exist in group 006 .
My Column Name in user table name :user_master
{
user_id varchar2(15),
grp_id varchar2(10)
}
what sql statement i apply to hide and show Tab.
I have an IR where I have to show a column in report, but hide it while downloading to CSV.
I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF') I also have a column where I have to hide it in the report, but show it while downloading to CSV.
I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2
I have following problem I have simple script in bash where I connect to db and launch simple select.
username:$(value)@host...
Problem is that i want to hide the password or encrypt. currently as you can see Iam using variable (value) where the password is keep. the problem is that, mentioned script is launched by many people which are using the same user (monitor). the variable is read from a file where user (monitor ) has access its in the same directory.
is there any way how to solve it ?
for e.g.
1. to put the file with password in another folder where the user (monitor) has no access to see the file.
2. to decrypt the password, but I have no clue how to do it .
when i want to call report from form how i can hide user name and password from the link in 10g ??
View 1 Replies View RelatedIs it possible to detect the status of Hide / Show Region.
I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:
$("RX.uRegionControl").click();
$("RY.uRegionControl").click();
.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.
Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No
- Edit
- First Name
- Last Name
- Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
But it not working for me? Where am I go wrong?
I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.
View 2 Replies View Related