Reports & Discoverer :: How To Convert Data From 6i To Oracle Table
Jul 10, 2011How To Convert Data from Reports 6i to oracle Tables.
View 2 Replies
ADVERTISEMENT
Reports & Discoverer :: Convert Oracle Report To PDF?
May 15, 2013what is the code for converting oracle reports to pdf.
View 11 Replies View RelatedReports & Discoverer :: Convert Oracle Report To Excel Format
Nov 10, 2012i m using oracle 9i (9.2.0.8.0) & developer 2000..I am getting below mentioned error when i convert Oracle Report to excel format.
"Report Builder
REP-1401:'afterreport':Fatal PL/SQL
error occurred ORA-43356 : Message 43356
not found; product = RDBMS ; facility = ORA "
Reports & Discoverer :: Convert Number From Arabic To English In Oracle Report Builder
Aug 5, 2011how can convert number from Arabic to English in oracle report builder
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 :: Convert RDF To REP
Mar 29, 2012I am using reports builder 6i version. I have couple of reports developed in RDF format and it is working fine in Oracle apps 11.5.10 server.
I converted the RDF to REP(using File->Administration->Compile) for some security reasons and moved this .REP to same Oracle Apps 11.5.10 Server but the program ends up with this below error.
REP-0002: Unable to retrieve a string from the Report Builder message file.
REP-1439:
Reports & Discoverer :: How To Convert Report To MS Excel And PDF
Mar 16, 2011how to convert report to ms excel and PDF. for example emp table report convert to ms excel and pdf.
View 1 Replies View RelatedReports & Discoverer :: Convert Matrix Report Into XLS
Nov 5, 2011i have convert many report's in xls, but that report's are not group field's
but this report is group by field, so the data can not be fitted in correct position
Reports & Discoverer :: Convert Report To Excel File
Sep 23, 2006How can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows .
View 25 Replies View RelatedReports & Discoverer :: Convert Report To Image Programmatically?
Feb 24, 2013Is there any way (bean / oracle code) to convert report to image Programmatically.
View 2 Replies View RelatedReports & Discoverer :: Possible To Convert Small Application To EXE File
Mar 15, 2011I have a small application with 5 forms and a small database. Is it possible to convert it into an exe file?
View 4 Replies View RelatedReports & Discoverer :: Convert Exponential Number Into Pure While Writing On Excel Using Builder
May 16, 2013How to convert exponential number into pure number while writing on excel using report builder.Excel only takes 15 digit as pure number and remaining number it converts into zero or you can say in exponential form.
View 4 Replies View RelatedReports & Discoverer :: How To Capture Runtime Reports In A Table
Jun 16, 2011i have created a report in dis report i created bind parameters..how to capture these parameters into a table(for this i hav created a new table) means if i pass delivery_id at runtime
i need to insert this value into what ever i hav created table next time if i pass same value i need to update that record where should i write dis code in a report and can any one send script for this.
Reports & Discoverer :: Reports Based On Data
Apr 30, 2013I have a doubt that can we make a report on sum of the salary record wise and grouped by dept number?
like as shown BELOW
Dept No Dept Name
10 Accounting
Employee ID Name Salary Sum Salary
7782 CLARK 2450 2450
7934 MILLER 1300 3750
7839 KING 5000 8750
Dept No Dept Name
20 Research
Employee ID Name Salary Sum Salary
7369 SMITH 800 800
7788 SCOTT 3000 3800
7902 FORD 3000 6800
Dept No Dept Name
30 Sales
Employee ID Name Salary Sum Salary
7844 TUNER 1500 1500
7499 ALLEN 1600 3100
7521 WARD 1250 4350
7900 JAMES 950 5300
emp table
Name Null? Type
----------------------------------------- -------- ------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
dept table
Name Null? Type
----------------------------------------- -------- --------------------------
DEPTNO NOT NULL NUMBER
DNAME VARCHAR2(15)
LOC VARCHAR2(15)
Reports & 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 :: 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 :: Column Headers Repeating In Oracle Reports 10g
Mar 19, 2013I'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
Reports & Discoverer :: Automate Oracle Reports Execution
Feb 10, 2012Any way to automate a job to execute several Oracle Reports to run at the end of every month and either email them to a list of people or possibly save them to a location on a network drive.
At first, I started out with 2 avenues of thought:
1) The following link raised the option of an Oracle Scheduler, but from my research, the scheduler only runs database jobs, shell scripts, batch files, etc.:
[URL]......
2) I was thinking about possibly creating a database job of some sort to call the reports, but from the following link, I've determined that one cannot create+call a stored/database procedure to run Oracle Report files. So there goes my second hope.
[URL].......
So, it appears that the scheduler won't meet my requirements and now I think I'm almost out of options.
My last resort is creating a database job that queries required information and spooling the data + various formatting "stuff" into a txt file. Then, that txt file would be my report. This seems a little savage and I would like to think that there's a ay to automatically run an .REP against a database and save an electronic copy of the report somewhere.
Is it possible to automate the execution of Oracle Reports and then saving the report in a particular format (xls/pdf/rtf/etc.)?
Reports & Discoverer :: Moving Fields In Oracle Reports?
Nov 13, 2010In my requirement i have to move a field from bottom to the first page of report. I try to drag the field but i think it's in multiple frame .i am very new to oracle how can i work with multiple frame in layout wizard.
View 2 Replies View RelatedReports & Discoverer :: Object Alignment In Oracle Reports
Oct 25, 2011I am unable to properly align two objects in the layout editor in Oracle Reports. The form report I am trying to design must be perfect and I need to highlight a particular report object (data item) by adding a narrow box (boilerplate) next to it on the left hand side, which is filled with a contrasting colour and contains an asterisk.
The problem is this: I cannot seem to align them properly (horizontal stack, align top). Even if I use the 'size objects' option to make them exactly the same vertical size, the align option stated above does the horizontal stack, but vertically they are not aligned - nor can I manoeuvrings the boilerplate box into place manually.
Reports & Discoverer :: Oracle Reports In Excel Format
Jan 14, 2010The environment of my company consist of an ERP system developed using Oracle Forms 4.5 and Reports 2.5. Now, due to increase in business activities, there is a lot of requests from users for reports in Excel sheet.
Our company is planning for Oracle ERP Rel 12....and it is under process of analysis..due to which there is no chance of upgrade to latest Developer Suite.
As of now, to fulfill user requirements of Excel based reports...what do you think is best and permanent solution? Is there any plug-in or Business Process or Business Intelligence application llike ORACLE BI Spreadsheet plug-in..which meets our demand.
As of now provide users with options to run the report and generate output in HTML format, from there, they copy it to Excel..but this process is not at all user friendly and feasible.
Reports & Discoverer :: Call Oracle Reports From PL/SQL
Mar 15, 2013For a requirement, i need to call an Oracle Report from a PL/SQL Package or Procedure. Explain on how this can done. Mine is an Oracle Reports 6i version.
View 1 Replies View RelatedReports & Discoverer :: Symbol In Oracle Reports
Oct 29, 2011I have a report I am currently working on...see attached file. I have circled two symbols. I know the one on the left is "page break after" but I am not sure why this field would have this setting.
Tell me what the symbol on the right means? Also, I have confine and flex set to "off" on all fields and items, yet when I move one of the fields other fields start to move as well. I am supposed to swap the bill to and ship to address which should be simple but so far it's not.
Reports & Discoverer :: Converting Old 2.5 Oracle Reports To 6i
Aug 5, 2009I have .rdf files from mid 1990's ( I'm not sure what is the version, perhaps 2.5 ) and now I would like to modify them by Oracle Reports Builder 6i or 9i. If I try to open those files by Oracle Reports Builder 6i I get the following error message:
REP-0110: Unable to open file 'C:file.rdf'
REP-1070: Error while opening or saving a document
So I made a conclusion that those .rdf files are too old for 6i. Do I need to convert, and especially how, those files? .rdf files where copied from Unix machine to Win XP machine where Oracle Report Builder is installed.
Reports & Discoverer :: Using LIKE Command In Oracle Reports
Oct 10, 2012i want to use the like command inside report query. i am giving my query below. i am not getting the required result.
select sum(debit) from doc_Detail where doc_acct no like ':acctno%';
Reports & Discoverer :: Oracle Reports In A Field
Mar 14, 2012I have a table (medicine_frequency) which has the following items:
-----------------
AGE
DRUG_DESCRIPTION
FREQ
MORNING
NOON
EVENING
BEFORE_BEDTIME
OTHER
-----------------
I have to prepare a report in such a way that in a field it has to display the values of morning/noon/evening(once if all three are there) like 'Take 1 tablet'