DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

repot order by problem

mfa786Oct 11 2006 — edited Oct 15 2006

sir
when i use this query

SELECT VOUMASTER.discription,cheqno,NVL(SUBSTR(VOUMASTER.cheqno,10,10),0) AS chqno,VOUMASTER.entdate,VOUDETAIL.vno,VOUDETAIL.accid,VOUDETAIL.debit,VOUDETAIL.credit,CHARTOFACC.title AS acc_title,PARTYTABLE.title AS PARTY,DEPARTMENT.title AS DEPT
FROM VOUDETAIL,VOUMASTER,CHARTOFACC ,PARTYTABLE,DEPARTMENTMFA DEPARTMENT WHERE
VOUMASTER.vno=VOUDETAIL.vno AND
VOUDETAIL.accid=CHARTOFACC.accid AND
VOUMASTER.partyid=PARTYTABLE.partyid(+) AND VOUDETAIL.deptid=DEPARTMENT.deptid(+)
AND SUBSTR(VOUMASTER.vno,1,2)='BP' AND NVL(SUBSTR(VOUMASTER.cheqno,10,10),0) >0
ORDER BY chqno ASC

then get rigth result
chqno date
11009201 04-JUL-05
11009201 04-JUL-05
11009236 01-JUL-05
11009236 01-JUL-05
11009236 01-JUL-05
11009237 01-JUL-05
11009237 01-JUL-05
11009238 01-JUL-05
11009238 01-JUL-05
11009239 01-JUL-05
11009239 01-JUL-05
11009240 01-JUL-05
11009240 01-JUL-05
11009243 19-JUL-05
11009243 19-JUL-05
11009243 19-JUL-05
11009247 01-JUL-05
11009247 01-JUL-05

but when this query use in report then system not give me right result
not sort on chqno give me result unorder such as
start from

11009236
11009237
11009238
11009239
11009231
11009206
11009246
11009250
11009255
11009256
11009235

this type of result
sir how i get right restul and give me idea how i set order by through use property
like as form order by property
please give me idea how i set order by by useing report order by property

thank
aamir