Oracle Reports 6i Questions


User input
How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for the search criteria. Is there any [...]

Answer Question   |  March 1, 2013  1:45 PM
Oracle Reports 6i, Oracle Reports Builder, SQL Query
asked by:
15 pts.

How to change page length of report?
Im trying to create report in reports6i and I just want to know how to adjust the page LENGTH from 66 to 56.

Answer Question   |  October 9, 2012  3:39 AM
Oracle Reports 6i
asked by:
5 pts.

How can I Send report output to 3 different printer programatically
Dear Friends How can I Send report output to a printer, I have three different printers in three location so how can I Send the report output to those three printer automatically when the user press the print button . please give an example if it is possible Waiting for your valuable answer. Best regards [...]

Answer Question   |  February 28, 2012  6:38 AM
Oracle 6, Oracle Reports, Oracle Reports 6i
asked by:
35 pts.

How to call word file from oracle report/forms 6i
how to call word file from oracle report/forms 6i

Answer Question   |  April 12, 2011  5:13 AM
Oracle Forms 6i, Oracle Reports, Oracle Reports 6i
asked by:
45 pts.

Increasing printable area in oracle report 6i
Hi all.. i am having a problem. i want to increase the printable area of the report without modifying the page size. if i modify the printable area automatically page size is getting modified in oracle reports. Is there any way we can modify only the printable area?????

Answer Question   |  April 19, 2011  8:40 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters
asked by:
15 pts.

Converting Oracle Report 6i into Excel
the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in [...]

Answer Question   |  January 21, 2011  10:55 AM
Excel 2003, Office 2003, Oracle Reports 6i, Oracle Reports 6i to Excel
asked by:
35 pts.

Oracle Reports 6i
Currently my report is being displayed in landscape style. i want it to be displayed by rotating it in a 90degree angle. For example, say my current report is ‘|’. I want to display it as ‘-’. The reason behind it was, the increase in the number of columns. Do we need to make any [...]

Answer Question   |  November 17, 2010  6:26 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports Developer, Oracle Views
asked by:
15 pts.

Oracle Reports 6i tables
Hi All, I am working in Oracle 6i reports, I want to hide some report columns value at runtime. For example if dataentry operatior run a invoice report the value columns are print like ‘**********’ otherwise it will print original value. The users are controlled in a seprate table. Using that table I want to [...]

Answer Question   |  September 29, 2010  11:50 AM
Oracle 6i, Oracle Reports, Oracle Reports 6i, Oracle Tables
asked by:
5 pts.

How to call report 6i from forms6i defining the username/password
I am using forms6i and Report6i, Now I am trying to connect to another user to run the report. How to call report 6i from forms6i defining the username/password

Answer Question   |  January 24, 2011  10:10 AM
Oracle, Oracle Forms, Oracle Forms 6i, Oracle Reports, Oracle Reports 6i, Oracle User Profiles
asked by:
5 pts.

Oracle Reports Builder
Hi, i have one query plz help me on the same…. I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. [...]

Answer Question   |  January 17, 2011  11:11 AM
Oracle development, Oracle Reports, Oracle Reports 6i, Oracle Reports Builder, SQL Query
asked by:
5 pts.

underscore is replaces with space oracle reports 6i
I have a problem. I am setting value of a varchar2 variable and including an underscore in taht string value. but when I print it, this underscore is replaced with a space character. What can I do in this situation. plz help me out.

Answer Question   |  May 11, 2010  8:08 PM
Oracle 6i, Oracle Reports, Oracle Reports 6i
asked by:
5 pts.

Display Report Preview on full screen
When a report is executed the output is not displayed in full screen. the end user has to use the maximize button to do so. I would like to have the report displayed on full screen

Answer Question   |  March 30, 2010  12:35 PM
Oracle 10g, Oracle Reports, Oracle Reports 6i
asked by:
10 pts.

Oracle Report 6i and Oracle 11g database
I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?

Answer Question   |  August 10, 2011  6:22 AM
Oracle 11g, Oracle 6i, Oracle Database 11g, Oracle Reports 6i, Oracle upgrades
asked by:
5 pts.

Margin in page setting for Oracle 6i
Is there any way for Oracle6i reports printing to base the margin on the top-left most corner of the physical paper and not on the starting top-left part of the printable area of the paper which is dependent on the printer’s settings? My report has a top margin of 1 inch and left margin of [...]

Answer Question   |  September 30, 2009  6:09 AM
Oracle 6i, Oracle Reports 6i
asked by:
5 pts.

oracle6i reports- how to select new column in parameter in cheque printing report
how to select new column in parameter in cheque printing report (oracle6i reports)

Answer Question   |  September 10, 2009  2:37 PM
Oracle 6i, Oracle Reports, Oracle Reports 6i
asked by:
16,755 pts.

Printing Report using ORACLE 6i Report
I have install ORACLE 6i Report and devices such as printer EPSON TMU295 using serial cable, and EPSON TMU220 using usb. How can i print report which generate from ORACLE 6i report to make sure it can print through 2 printer on the same time?

Answer Question   |  September 10, 2009  4:28 AM
Oracle 6i, Oracle printing, Oracle Reports, Oracle Reports 6i
asked by:
20 pts.

Oracle Reports 6i prints blank reports
I have an Oracle 6i report that is invoked by program that sends a command line instruction. Unfortunately, the report prints out as a blank page. Even if I run the report from the command line, it prints out as a blank page, however, if I run the report in Report Builder, and then print [...]

Answer Question   |  September 1, 2009  3:06 PM
Oracle, Oracle 6i, Oracle Reports, Oracle Reports 6i
asked by:
765 pts.

how do I install Oracle Reports 6i Runtime on IBM HttpServer?
how do I install Oracle Reports 6i Runtime on IBM HttpServer?

Answer Question   |  August 12, 2009  1:25 PM
Oracle 6i, Oracle Reports, Oracle Reports 6i
asked by:
5 pts.

Oracle Reports problem
I am migrating an old classic asp with vb5 mts application from Windows NT to a Windows 2003 server (with no documentation). The application is used to send faxes via Goldfax, and it creates the faxes using Oracle Reports 6i, which is where I am having the problem. In order for Goldfax to be used [...]

Answer Question   |  August 14, 2009  11:00 AM
COM+, Goldfax, Oracle Reports, Oracle Reports 6i, Windows Server 2003
asked by:
765 pts.

oracle reports 6i – compatibility with windows 2003 64 bit
I have a set of oracle reports duly compiled on oracle reports 6i- working very fine on windows 2003 server with 32 bit architecture. – We have moved to 64 bit architecture to over come the limitation of RAM of 4 gb as we have 16 GB on the server left unrecognized. May any one [...]

Answer Question   |  August 6, 2009  11:57 AM
Backup and recovery software; Windows Server 2003, Oracle 6i, Oracle Reports, Oracle Reports 6i, Windows Server 2003 64 bit
asked by:
5 pts.