Reports & Discoverer :: Created A Report To Generate Details Of Officials
Dec 4, 2010
we have a admin wizard where in there are 850 officials whose details are like
emp id
date of birth
date of joining
basic pay
photo
etc........
i have the photos of the officials out of the data base.i have created a report to generate the details of the officials. what i would like to have is to get the photo of each official from the file which is not in the data base.
i have the command in pre_form read_image_file('path where the photos are','msg.mcn');
this gives the same photo to all the officials. how do i be able to link the photos to their emp id and get it.
View 5 Replies
ADVERTISEMENT
Aug 25, 2011
Is it possible to save a report directly in a table instead of the typically destination? (file, cache,...)
View 4 Replies
View Related
Apr 11, 2013
How to generate a report and straight send it to an Email? I want to match student reg number and the parents email provided .
View 1 Replies
View Related
Aug 22, 2007
how to generate matrix report to excel file. i have done this . but the exact layout is not getting displayed in the excel file. I have attache the layout i ma trying to export to excel.
View 8 Replies
View Related
Nov 24, 2011
I created an xml report of output type 'xsl'. When the report output is generated for more than 65,536 rows then the report out put is not opening. generate excel report output with maximum no of rows.
View 1 Replies
View Related
Sep 16, 2002
while trying to generate a PDF or HTML file from a report previewer, I came upon a REP-0999 error message and the previewer was closed!
View 8 Replies
View Related
Nov 19, 2010
I need to generate reports in oracle.I want to use if condition in the query. but I'm unable to use if condition in query. how can i use if condition? is there any other method to do this?
View 4 Replies
View Related
Mar 28, 2012
during the migration to 11g we had a problem with pdf font.
In 10g oracle report the pdf are generated correctly while in 11g all the character are shrink in the pdf file.
I attached the same file generate with oracle reports 10g.
View 3 Replies
View Related
Jul 6, 2010
very new to Oracle. how to generate the library
View 7 Replies
View Related
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
Aug 18, 2010
Is it possible to generate .pdf file with password protection.
View 2 Replies
View Related
Feb 17, 2012
I have a Report which run in character mode format, well i cannot convert or Generate to File as a XML File.
XML Conversion Error:
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred. ORA-01403: no data found
PDF Conversion Error:
REP-1920: Character mode runtime incompatible with DESFORMAT of PDF, HTML, HTMLCSS, or RTF
But, when i change Character Mode to Bitmap or Default i can able to Generate to File.
So i Like to know is it possible to Generate to File in Character Mode?
View 1 Replies
View Related
Sep 20, 2012
How can i print a report name with full path at left bottom on report.
View 3 Replies
View Related
Nov 29, 2011
I am trying to open report in parameter form in drill down report.
View 7 Replies
View Related
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
Jun 23, 2010
When I try to manage the report the Discoverer application frozen.
View 5 Replies
View Related
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
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
Aug 23, 2011
How to merge multiple reports in one report in reports 6i.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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