Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kzhangkzhang

    How to force print text even if there is no data assiciated

    Hi I am working on a Oracle 6i report. The final report looks like: ==================================================== Sample Oracle Report Org ID: 1 Org Name: MUS Org ID: 2 Org Name: MFG ==================================================== The report layout looks like: Org ID...
  2. kzhangkzhang

    Help with SQL*PLUS report format issue

    Hi All: I am creating a SQL*PLUS (not Oracle report) report. The code segment liks following: ============================================== set newpage 0 set pagesize 55 BREAK ON component desc quantity select ..... from .... // ignore the actual syntax...
  3. kzhangkzhang

    SQL*PLUS report format issue: Is that possible

    Hi All: I am creating a SQL*PLUS (not Oracle report) report. The code segment liks following: ============================================== set newpage 0 set pagesize 55 BREAK ON component desc quantity select ..... from .... =============================================== When I run...
  4. kzhangkzhang

    How to not print blank lines in Oracle report 6i

    I am using Oracle 6i. Here is an example of output of my report: Component Seq SubInv Quantity ========= === ====== ======== 018-1071 10 test1 10 test2 20 <=== blank line test3 30...
  5. kzhangkzhang

    extra blank spaces printed between lines

    I am using Report6i, in the layout model, I created two lines as following (each line consists of a text object and field object): supply subinventory1 : F_supply_sub1 supply subinventory2 : F_supply_sub2 Also, I group each line (text + field)into a frame. When I printed out it, there are...
  6. kzhangkzhang

    Good online documents for Oracle report tips

    Does anyone knows any good online documents for tips/demo/example for using report 6i?
  7. kzhangkzhang

    How to dynamic print out multiple copies of report

    Hi: I am modified an Oracle report using report 6i. I need figure out how to dynamic print out multiple copies for the same report based on the value of a column retreived from a table in the database. Can I do this in Oracle report 6i? Can I dynmaically reset the value for "Copies" system...
  8. kzhangkzhang

    Command line for edit and run Oracle report 6i on Unix

    Hi All: What is the command line that 1) Launch the Oracle Report Builder6i on Unix box (e.g. HPUX) 2) run the Oracle report 6i from command line on Unix box. Where can I find the document for Oracle report builder 6i on unix box where Oracle 9i is installed. Thanks!
  9. kzhangkzhang

    How to get a complete list of all Oracle V$ virtual tables

    Hi All: Is there a way to list all Oracle V$ virtual tables? Thanks!
  10. kzhangkzhang

    Where to find the session information

    Hi All: We can use alter session command to change a lot of session information (e.g. ALTER SESSION SET OPTIMIZER_MODE = RULE). My question is how to find all session information? What command can tell me the value for OPTIMIZER_MODE of my current session? Thanks!
  11. kzhangkzhang

    Report Builder 6i: How to control sequence of XML tag in a group

    Hi All: I am using Oracle Report Builder 6i to create a Oracle report. The output of this report will be an XML file. My question is: In a group object, how to control the actual sequence of XML elements output? I am adding one new column (col_B) to a group and I want the XML of that new...
  12. kzhangkzhang

    Can't run vanilla Oracle &quot;Packing Slip Report&quot; from Report Builder

    Hi All: I am kind of new to Oracle Report development. Here is my case: My company is running Oracle 11.5.9 Oracle application with 9i database engine. I have Oracle Report Builder 6i (with latest patchset 15 applied) installed on my desktop (Windows 2000) Step: 1) I copied the vanilla...

Part and Inventory Search

Back
Top