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.
I am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedI 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[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.
I want to create report using this query, is there any option?
declare
cursor c2 is
select epi_id, epi_code, epi_name
[Code].....
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]...
I know lexical parameter concept..but i want a demo report which will use lexical parameter...
View 1 Replies View RelatedI 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).
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 RelatedI 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 Relatedhow to create link for uploading file from report
View 2 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 Relatedi 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 RelatedI 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 RelatedHow can i print a report name with full path at left bottom on report.
View 3 Replies View RelatedWhen I try to manage the report the Discoverer application frozen.
View 5 Replies View RelatedIs 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.
How to merge multiple reports in one report in reports 6i.
View 1 Replies View Relatedhow to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedI 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 .
How to Call a Report from a Report?
Not from a form but a Report from a Report?
We have a Oracle 10g database with RAC and Dataguard. When we look at the AWR report, the wait time shown by Oracle for this database is very high.
Service Time : 15.36%
Wait Time : 84.64%
This would imply Oracle is waiting for resources 85% of the time and only processing SQL queries during 15% of its non-idle time. However when we check the OS (RHEL), the iowait is only about 10% and the CPU is 80% idle. This means that that processing horsepower is available.
As such, the results between the OS and Oracle database (AWR report) seems contradictory. OS says we have CPU/IO capacity, however Oracle says we don't.
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 RelatedThe 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)
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 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]...
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.
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 RelatedI 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