How to install Oracle Forms and Reports 11g on Windows XP 32bit

How to install Oracle Forms and Reports 11g on Windows XP 32bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows XP 32bit
reqs: WinXp SP2 or later, 1GB Memory,
time: Oracle Weblogic: 10 min,
Fusion Middleware: 40 min setup, 50 min config

  1. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the i586 JVM installer package (about over 1/2 GB)
  2. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the i586 zip files (about 2.5 GB in chunks of ~500MB).
  3. Make sure you have at least
    • an i586 compatible CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install

If needed, download Java JDK 6u25 i586 (jdk-6u25-windows-i586.exe). (more…)

How to install Oracle Forms and Reports 11g on windows 7 64bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit
reqs: Win7 x64, 1GB Memory, Administrator
time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config

  1. Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe)
  2. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the x64 JVM installer package (about 1 GB)
  3. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the x64 zip files (about 2.5 GB in chunks of ~500MB).
  4. Make sure you have at least
    • a 64bit CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install (more…)

count a column, then count the group -oracle reports

You want to the following report output (ProdA and ProdB are within same column):

Prod-Id | A | B | Subtotals
123 | 4  | 3 | 7
124 | 2 | 5 | 7

Columns: prod_id, prod_code, prod_type
Group by: prod_type

  1. After grouping your columns, create formulas for data A, B, All (within group-2):
    [sql]if :prod_code = ‘A’ then –set ‘B’ for second formula
    return 1; –counts 1 on every row of prod_code = ‘A’ (or ‘B’)
    end if;

    if :prod_code is not null then –find all items other than ‘A’ or ‘B’
    return 1; –counts 1 on every row of prod_code = null
    end if;[/sql]

  2. Create a Count for each data type A, B  (within group-1, reset at group-1)
  3. Do a Sum based on the “all items” Count (within group-1, reset at group-1)
  4. Place fields of steps 1,2,3 in a repeating region of group-1

You should have the results as seen in example above.