-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|