Reports & Discoverer :: 6i To 10g Report Button Code Conversion?

Apr 6, 2012

We are converting Oracle 6i reports to 10g. I have a report with a button on it that when clicked, it runs PL/SQL code in a program unit defined within the report. The only documentation I have run across says to replace buttons with a hyperlink but this seems to refer to when a report calls another report. This is not the case for this situation.

The button on the report came into 10g as a Text Item. I tried applying the following documentation to the hyperlink property:

"Example 5: Static hyperlink The following example shows a value for the Hyperlink property that specifies a link to a destination identified as LINK1: #LINK1"

The program unit is named: U_UPDATEBUTTONBUTTONACTION and I referenced it as #U_UPDATEBUTTONBUTTONACTION in the hyperlink property.

The open browser window is not what I need.

View 3 Replies


ADVERTISEMENT

Reports & Discoverer :: Digits Conversion - Report Developed In Builder

Oct 9, 2012

I am facing an issue here at my workplace, there is a report developed in report builder , the user wants to see the digits in arabic.

View 4 Replies View Related

Reports & Discoverer :: Bar Code Reader Will Readout Code

Feb 12, 2009

I have no knowledge about Barcode. The problem is an issue of Loyalty Cards of a Hotel and Restaurant to various customers and then these cards will be presented by the customers time to time in the Hotel as well as Restaurant. The Owner of the Hotel and Restaurant wants to generate separate barcode for each card and when this card will be presented then the bar code reader will readout the code and the system will calculate the amount of discount/rebate. Because if the data entry operator enter the code of the card through key board the it will be a chance of leakage or misuse of that card.

View 8 Replies View Related

Reports & Discoverer :: Code To Compute Price INCL Of VAT?

Jan 30, 2012

i have a Field item on my report which i would like to show "Price INCL of VAT". Any PL/SQL code or trigger to do this? VAT is 16%

I'm a Forms programmer, not so familiar with Reports.I suspect, it should be something like this:

F_1 := F_1 * 1.16

View 25 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 :: 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 Bar Code In 2.5 (Oracle Apps 10.7 Char)

Apr 4, 2006

Printing a bar code (such as a pick slip number e.g. 223456) in Oracle Applications 10.7 char, reports 2.5 on a genicom (dot matrix)..I was unable to find any fonts for this when I searched.

View 3 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 :: Error Code ORA-00918 Column Ambiguously Defined

Jul 18, 2013

I have written this code below in Disco Admin 10g but get Ora-00918 column ambiguously defined error even though I have used alias in the table name.

Select

porh.segment1
,Porh.creation_date
,Porh.last_update_date
,porh.closed_code
,porh.authorization_status
,porh.description
,porh.note_to_authorizer
,porh.cancel_flag
,porh.enabled_flag
,porl.line_num
[code]....

View 4 Replies View Related

Forms :: Run Report Developed By Crystal Reports By Click On Button In Oracle Developer 6i?

Dec 19, 2011

I want to run a report developed by crystal reports by click on a button in oracle developer 6i.

Is it possible. If yes then how can i do this.

View 8 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 :: 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 :: 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 :: Report Printing In 11g

Sep 25, 2012

I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.

View 1 Replies View Related

Reports & Discoverer :: Unable To Run The Report In 10g

Dec 6, 2012

The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.

I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)

View 3 Replies View Related

Reports & Discoverer :: How To Run Report In Menu

Oct 19, 2011

How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?

View 5 Replies View Related

Reports & Discoverer :: Report In Arabic PDF?

Oct 6, 2010

We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.

we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"

[code]...

View 3 Replies View Related

Reports & Discoverer :: How To Create Report

Apr 30, 2013

I want to create report using this query, is there any option?

declare
cursor c2 is
select epi_id, epi_code, epi_name

[Code].....

View 4 Replies View Related

Reports & Discoverer :: Report Key Not Found

Nov 4, 2010

Have there any limitation on report key(Number of report key) on cgicmd.dat file?

REP-52005: The specified key mrr does not exist in key map file.

But this key 'mrr' exists on cgicmd.dat.

View 1 Replies View Related

Reports & Discoverer :: One Report Two Pages

Oct 3, 2011

i'd like to fit two pages in one report. i.e i'd like to divide A4 paper into 2 pages. How to do that in report 10g . like in the PS

View 2 Replies View Related

Reports & Discoverer :: How To Format A Report

Apr 12, 2011

I am beginner to reports working on reports 10g..Actually i have to print addresses of customer on a report. Using one of the layout style i am trying that. But i have a requirement. i need to print only the city name. they should not be any town.. How can i format when town field is null then i should not show town in the report?

View 1 Replies View Related

Reports & Discoverer :: How To Kill A Report Job ID

Jul 6, 2011

i used below code to call Report from Form

Function to call procedure to run report:

DECLARE
report_id Report_Object;
v_report_other VARCHAR2(4000);
vc_connect varchar2(50);
BEGIN
--Call run_report_object
[code]......

its showing report output in a new window, but problem is that if i copy the url, then close current report browser window, start new IE session and paste the copied url it showing the same report... but i don't want to allow this and want to Kill the current job id ( while it displaying the same report ), how i can do this?

View 1 Replies View Related

Reports & Discoverer :: AWR Report On SQL Developer

May 14, 2013

How can I run an AWR report through SQL Developer? I do not have EM installed on my Oracle 11g database.

View 1 Replies View Related

Reports & Discoverer :: Hyperlink In PDF Report

Sep 14, 2010

when i open one pdf report hyperlink is attached in this report & we can open again a new report through this hyperlink when i click on this hyperlink & return back to main report then it is starting from first page

suppose i m in 4 page & use hyperlink & open new report after that when i return back to main report it starting from first page..is there any solution so that i will return back on same position from where i have click the hyperlink instead of first page

View 4 Replies View Related

Reports & Discoverer :: Drill Down Report From Another One

Jun 27, 2011

A drill-down report (B) is called from another drill-down report (A) which opens correctly, but when I close report (B) all reports including the master report are closed automatically.

View 4 Replies View Related

Reports & Discoverer :: Sub Drill-Down Report

Feb 3, 2012

I'm calling sub drill-down report (Report C) from a drill-down report (Report B) using buttons. Report opens correctly but when I tend to close the sub drill-down report (Report C), all reports in hierarchy including the main report (Report A) also close down after raising an exception "An un-handled win32 exception raised in RWRBE60.EXE [3300]"

Report Calling Sequence:-
Main Report => Drill Down Report => Sub Drill Down Report

View 3 Replies View Related

Reports & Discoverer :: Report Clarification?

Oct 1, 2013

I am developing One new Label Format report (Totally three Different label Format)each label Different size,Three different printer.

How to default printer on each reports

View 2 Replies View Related







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