Reports & Discoverer :: Create Report From Cursor?

Jun 18, 2012

I want to create report against my below query, how?

Declare
Cursor Emp_Cur is
Select epi_id, epi_code
From emp_personal_info
Where epi_status = '73'

[code]...

View 3 Replies


ADVERTISEMENT

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 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 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 :: How To Create Report Using Lexical Parameter

Feb 17, 2011

I know lexical parameter concept..but i want a demo report which will use lexical parameter...

View 1 Replies View Related

Reports & Discoverer :: How To Create Half Size Report

Nov 29, 2011

I am using the Report 6i. By using the same tool i created a report. It printing portion is working correctly (that is printing only Half of the page but the next page is move to after scrolled to balance of A4 size). But i want to print with in A4 two pages.

I created using the following property setting....

Layout model-main section-property

Section
width 8.5
height 5.9

Character Mode
Report width 80
Report Height 35

But it utilizing to print half page and balance is scrolled then new page is start(new A4 next paper).

View 1 Replies View Related

Reports & Discoverer :: Create A Report That Shows Only DD-MON Of A Birthday

Jun 9, 2010

I need to create a report that shows only the DD-MON of a birthday while ignoring the year and then having the output in DATE form so I can sort chronologically. My input is in DD-MON-YYYY format.

I have used Date_Trunc to pull out the month and day but the 29-Feb dates are giving me the ORA-1839 error message.

View 9 Replies View Related

Reports & Discoverer :: How To Create Text File Of Report In 10g

Mar 18, 2013

How to create text file of report in 10g ? In reports 6i having default option in menu bar(mail). When clicking the mail option in reorts 6i it will attached to the outlook and we can sent. but in reports 10g not having that Option . It is possible in reports 10g?

View 2 Replies View Related

Reports & Discoverer :: Create One Inventory Label Report With Barcode?

Sep 18, 2013

I am trying create one Inventory label report with bar code ,This reports working fine stand alone,Once i am added this report on Oracle Apps concurrent Program ,Output came without bar code.

View 6 Replies View Related

Reports & Discoverer :: How To Create Link For Uploading File From Report

Feb 4, 2012

how to create link for uploading file from report

View 2 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 :: Create A Procedure In Program Unit And Assign Output To A Field In Report?

May 8, 2013

i just want to know how can i create a procedure in the program unit and assign the output to a field in the report.

View 7 Replies View Related

Reports & Discoverer :: Create A Report By Using One Field / Text As Columns Name In Layout But Display All Columns

Jun 16, 2010

I want to create a report by using one field and one text as columns name in layout but display the all the columns. I mention the 5 column names in query.how can I write function in summary column.

View 4 Replies View Related

Reports & Discoverer :: Building Reports In Dev - 10g With Ref Cursor Query?

Dec 27, 2011

i was searching for the example of subject mentioned and visited the following website

[URL]...

here is a tutorial to create such report, but i am confused as here in Report's Data Model they created 3 Ref Cursor Queries and did not Close the opened cursor, is there no need of this or any mistake or if it necessary, where have to Close the cursor?First, they have created following Packages

PACKAGE concl_cv IS
type conclass_rec is RECORD
(EMPLOYEE_ID NUMBER(6),
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(25),

[code]...

then, created Functions which created in Ref Cursor Query in Data Model
function q_portdescRefCurDS return port_cv.portdesc_refcur is
temp_portdesc port_cv.portdesc_refcur;
begin
open temp_portdesc for select department_id, department_name from departments;

[code]...

nothing here any Close cursor statement.i am trying to explore this area of the development.

View 2 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 :: 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 :: Global Cursor

Mar 18, 2013

I have a report,in which i have used a function and inside function i made a cursor.and that cursor is used by many functions .so i want to make it globally.so that i would be able to get it in all the function instead of making it in all the functions.

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 Create Oracle Reports With Java Barcodes

May 24, 2010

how to create Oracle Reports with Java Barcodes.

View 8 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 :: 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







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