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.
from r5objects obj,
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,
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.
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?
Click Here to Expand Forum to Full Width