Reports & Discoverer :: How To Generate The Library
Jul 6, 2010very new to Oracle. how to generate the library
View 7 Replies
ADVERTISEMENT
Reports & Discoverer :: Using If Condition To Generate Reports
Nov 19, 2010I 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 RelatedReports & Discoverer :: Generate PDF 11g?
Mar 28, 2012during 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.
Reports & Discoverer :: Generate PDF With Password?
Aug 2, 2011We 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.
Reports & Discoverer :: Generate Report To Database Table?
Aug 25, 2011Is it possible to save a report directly in a table instead of the typically destination? (file, cache,...)
View 4 Replies View RelatedReports & Discoverer :: Generate PDF File With Password Protection?
Aug 18, 2010Is it possible to generate .pdf file with password protection.
View 2 Replies View RelatedReports & Discoverer :: How To Generate Report And Send Straight To Email
Apr 11, 2013How 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 RelatedReports & Discoverer :: Unable To Generate To File XML In Character Mode
Feb 17, 2012I 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?
Reports & Discoverer :: Created A Report To Generate Details Of Officials
Dec 4, 2010we 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.
Reports & Discoverer :: How To Generate Matrix Report To Excel File
Aug 22, 2007how 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 RelatedReports & Discoverer :: Generate Excel Report Output With Maximum No Of Rows?
Nov 24, 2011I 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 RelatedReports & Discoverer :: Generate A PDF Or HTML File From A Report Previewer / REP-0999 Error
Sep 16, 2002while 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 RelatedReports & Discoverer :: How To Run Discoverer Reports In A Forms Menu
Jul 5, 2010how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies View RelatedForms :: Unable To Generate Reports
Jan 25, 2011I am using the following code to generate my report
pat:= :global.path||'us01127p4';
run_report('heboracle1.pace.internal:7778',
'r1',pat,'c:','c:','pdf','pacerep',pl_id,'yes',
'&co_code='||:global.co_code||'&type_sl='||mtype_sl||'&prog_sl='||:global.prog_sl||'&mode='||'default'||'&desname ='||:global.user_fname||'&destype='||'cache'||
'&to_no='||:to_doc_no||'&year='||myear||'&from_no='||:from_doc_no,'no','no','','wide180');
When i set my param form variable as 'Yes' the report parameters window pops up and when i press submit query the report gets generated. But if i set param form to 'No' then i get a msg saying
TERMINATED_WITH_ERROR-Report output aborted ORA-0000
if i put an exception i am getting a same msg.
The same code is working fine for other forms.
SQL & PL/SQL :: Generate Data Migration Reports
May 9, 2011I need to generate in report using PL/SQL code for counting the number of rows of all the tables from source and target database..The report should consist of following columns..
table name|source table row count|target table row count|mismatch|..provide me the PL/SQL code?
Generate Grid Control 10g Reports In Portuguese
Aug 31, 2011I am able to generate (and email) built in database space usage report, I have a requirement where the report has to be in portuguese language and not in english.
View 1 Replies View RelatedGenerate Filesystem Usage Reports From Grid Control10g?
Aug 31, 2011I am oracle 10g grid control.
I have a requirement where I have to generate monthly filesystem usage report(graphical) in an automated fashion,I checked the built in reports from the grid control 10g but not able to find any thing....
Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu
Dec 6, 2011Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies View RelatedReports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer
Mar 19, 2012When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies View RelatedReports & Discoverer :: Discoverer Admin - How To Copy Folder From One Instance To Another
Nov 9, 2011I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.
View 1 Replies View RelatedReports & Discoverer :: During Open Report The Discoverer Application Frozen?
Jun 23, 2010When I try to manage the report the Discoverer application frozen.
View 5 Replies View RelatedReports & Discoverer :: Provide Download Link To Blob In Database On Oracle Reports?
Aug 8, 2013My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?
Nov 2, 2010I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
Reports & Discoverer :: How To Call Oracle Reports Inside A Stored Procedure
Oct 14, 2010Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?
[code]...
Now, i want to convert this into oracle,plsql? Is it possible or not?
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.
Reports & Discoverer :: Oracle Reports Text Formatting As Runtime?
Aug 26, 2013I need the below output in oracle reports 6i.
this is a testing string retrieved from database.
now what i need is that to make bold the specific words in a string came from database.
Reports & Discoverer :: How To Execute Oracle Reports On A Developer Machine
Mar 25, 2013I migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?
When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.
Reports & Discoverer :: How To Create Oracle Reports With Java Barcodes
May 24, 2010how to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedReports & Discoverer :: Bind To Reports Server Rep_wwubh01ap45 Failed
Jun 9, 2006While accessing the reports i am getting the following error
Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.
I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.
Reports & Discoverer :: Hiding Reports Server Window - Specify Cmdkey
Jul 19, 2011We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.
WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||
[code]...
We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server
Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?
= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);
[code]...