Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: breaking the field?

    up to how many levels can we break the column like there are 8 fields and we want the report to be printed first field wise seconed field wise and then 3rd field wise.... and how can we set a field as break field
    Rishabh Agarwal

  2. #2
    Join Date
    Jan 2004
    Posts
    21
    I WANT THAT THE VALUE IN A CERTAIN COLUMN IN ASCENDING OR DESC. ORDER SHUD NOT REPEAT IF IT REPEATING VALUES ARE THERE THEN THERE SHUD BE A BLANK I USED A REPEATING FRAME BUT I THINK ITS NOT GOING TO WORK? CAN PLZ ANYONE HERE TELLME THE SOLUTION...
    Rishabh Agarwal

  3. #3
    Join Date
    Mar 2004
    Posts
    22
    i also have the same problem as i have 6 clumns in my report

    jobname mc no section production
    aaaa 22 1a 567
    1a 122
    2a 557
    2a 768
    23 7s 797
    7s 688

    above is the existing report

    i want

    jobname mcno section production
    asasas 22 1a 788
    423
    sum
    2a 799
    788
    sum
    23 7s 898
    747
    sum

    can anybody help us

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    Are you looking for something like this:

    PHP Code:
    SQLselect deptnuename from emp;

        
    DEPTNU ENAME
    ---------- ----------------------------------------
            
    10 james
            10 julie
            20 tom
            20 andrew
            20 grace
            30 chris

    6 rows selected
    .

    SQL> break on deptnu
    SQL
    select deptnuename from emp;

        
    DEPTNU ENAME
    ---------- ----------------------------------------
            
    10 james
               julie
            20 tom
               andrew
               grace
            30 chris

    6 rows selected

    Oracle can do wonders !

  5. #5
    Join Date
    Mar 2004
    Posts
    22
    yess
    exactly but i have to break on three fields in report 6i
    thanks for ur response

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •