DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Reports question

  1. #1
    Join Date
    Nov 2002
    Location
    Washington DC-Metro Area
    Posts
    7

    Angry Oracle Reports question

    I have a sql statement returning the correct dataset in the correct format ordered properly.

    However, upon using the sql statement as the query for a report in Oracle Reports, it stops ordering properly.

    Any ideas on what could be preventing the proper ordering of a otherwise good sql statement.

    SQL:
    select obj.obj_code,
    obj.obj_part,
    par.par_desc,
    mfg.mfg_desc,
    par.par_lastprice,
    par.par_uom,
    obj.obj_serialno
    from r5objects obj,
    r5parts par,
    r5manufacturers mfg,
    r5partmfgs mfp
    where ( obj.obj_part = par.par_code )
    and ( par.par_code = mfp.mfp_part )
    and ( mfp.mfp_manufacturer = mfg.mfg_code )
    and obj.obj_notused = '-'
    and obj.obj_obrtype = 'A'
    and obj.obj_person like :HAND_RECEIPT
    order by par.par_desc,
    obj.obj_serialno

    TIA,
    Chuck

  2. #2
    Join Date
    Nov 2002
    Location
    Washington DC-Metro Area
    Posts
    7

    Talking Nevermind

    I figured it out from repeated bashing of my head against the wall.

    You have to not order the sql coming in, but use the break order property of the report fields.

    Chuck

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Well, that's just wonderful. I quit my job to work on this problem full time, and you figured it out yourself. Now what am I supposed to do?

Posting Permissions

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


Click Here to Expand Forum to Full Width