Reports & Discoverer :: Calling Report From Form Asking Enter Password

Nov 28, 2010

I 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


ADVERTISEMENT

Reports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database

May 28, 2011

i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.

View 1 Replies View Related

Reports & Discoverer :: Hiding Username / Password When Calling From Hyperlink HTML?

Jun 30, 2010

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 Related

Reports & Discoverer :: Calling Report From Another Report

Aug 31, 2010

I created two reports separately.

1.pub.jsp
2.serc.jsp

what i need is i want to call the report serc.jsp from pub.jsp .

View 6 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

Dec 19, 2011

I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?

View 1 Replies View Related

Reports & Discoverer :: How To Create Password Protected Report File In Oracle 11g

Dec 21, 2011

I 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 Related

Reports & Discoverer :: Create Password Protected PDF Report Using Bursting In Oracle

Feb 21, 2012

i 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 Related

Reports & Discoverer :: Calling Reports From Stored Procedures?

Feb 23, 2011

Is there a way to call an oracle report (version 9i) from a stored procedure?

View 2 Replies View Related

Forms :: ORA-00933 When Calling Report From A Form

Nov 8, 2011

I have added a text field on forms 6i which calls reportAfter adding the new field called "appeal_name" it gave me the desired result for two three times and somehow after that it started to throw this error

ORA- 00933. I did try to find solution on the web and was given the hint that this occurs due to space or indentation in the coding. I have used Ltrim and Rtrim to remove any space when I added the text field "appeal_name", Following code has been added

if
upper(ltrim(rtrim(:appeal_name)))!='ALL' then
where_cond:=ltrim(rtrim(where_cond))||' and upper (tbl_donation.appeal_code)='''||:blk_hsbt.appeal_code||'''';
elsif :appeal_name is null then
where_cond:=ltrim(rtrim(where_cond))||' and tbl_donation.appeal_code is null';
end if;

View 1 Replies View Related

Reports & Discoverer :: Calling Program Units?

May 8, 2013

How to call program unit(procedure/function/package) in to report is it like formula column & placeholder?if not, how to call external (procedure/function/package) in to report

View 1 Replies View Related

Reports & Discoverer :: Generate PDF With Password?

Aug 2, 2011

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.

View 3 Replies View Related

Reports & Discoverer :: To Hide The Username And Password

Dec 20, 2010

I 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".

View 5 Replies View Related

Reports & Discoverer :: Generate PDF File With Password Protection?

Aug 18, 2010

Is it possible to generate .pdf file with password protection.

View 2 Replies View Related

Reports & Discoverer :: Create Password In Oracle Desktop

Oct 16, 2010

How user can change password in oracle discoverer desktop ?

View 1 Replies View Related

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related

Reports & Discoverer :: How To Hide Username And Password In Web Show Document

Jul 1, 2013

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 Replies View Related

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Anyway To Stop Report In Before-Report Trigger

Jul 24, 2011

Is there any way of stopping the report from executing in Before-Report Trigger.

Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.

how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.

View 2 Replies View Related

Reports & Discoverer :: How To Create Aging Report In Discoverer

May 28, 2010

[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?

Which tables should be refered for Ageing reports.

[Message #2] How to create an ageing report in discoverer?

Which tables should be refered for a Ageing reports.

Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.

View 1 Replies View Related

Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i

Aug 23, 2011

How to merge multiple reports in one report in reports 6i.

View 1 Replies View Related

Reports & Discoverer :: How To Call A Report From A Report

Aug 17, 2012

How to Call a Report from a Report?

Not from a form but a Report from a Report?

View 3 Replies View Related

Reports & Discoverer :: 10g Parameter Form Error?

Sep 26, 2012

While calling a report I am getting the following error.

REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.

When I call the same report through another PC it displays parameter form.

I am using Report Builder 10g.

View 3 Replies View Related

Reports & Discoverer :: How To Add Column In Oracle Form

Sep 12, 2010

I would like to know how can i add a column in existing report. I try to change SQL by doing this it does add that new column into group but when i try to run report i can not see that changes . then i try to do some changes in paper layout but i am not able to bring the changes in out put. i am new to this FORMS Reports . do i have to create a group again i am how can i change the layout in that report.

View 4 Replies View Related

Reports & Discoverer :: 10g - Parameter Form - Desname

Sep 3, 2010

In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?

View 1 Replies View Related

Reports & Discoverer :: Error On Creating PDF File From A Form?

Oct 14, 2010

When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6

View 2 Replies View Related

Reports & Discoverer :: Multiple Columns In Param Form

Jun 4, 2012

I am adding a parameter to the parameter form of existing reports based on a select statement and has two columns. That part is fine. However, Oracle reports is adding a dash between the two values. Still fine, but I am also adding a UNION with ALL in case the user wants to run the report for all values. In the Parameter form it looks like this:

ALL -
RBC - 111
RRG - 234
TEB - 445

How do I get rid of the dash for "ALL" since I did not physically add it? Below is my select statement for the parameter I created:

SELECT code,
code_num
FROM codes
WHERE code_num <> 0
UNION
SELECT 'ALL', ' '
FROM dual
ORDER BY 1;

View 8 Replies View Related

Reports & Discoverer :: Select List Of Values From Parameter Form?

Jun 9, 2012

I am trying to select multiple values from a parameter form based on a select statement.

I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.

View 1 Replies View Related

Reports & Discoverer :: How To Create Parameter Form In Descriptive Format

Jan 28, 2013

I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.

parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?

View 3 Replies View Related

Reports & Discoverer :: Changing Lov Font Face To Parameter Form

Apr 11, 2012

I need to change the font face from following lov value for parameter form, How?

SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved