Home » Developer & Programmer » Reports & Discoverer » report order by problem (not sort on cheqno)
report order by problem (not sort on cheqno) [message #197581] Wed, 11 October 2006 22:00 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member

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


sir my cheqno field is string i convert to number by using nvl(cheq,0)

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

Re: report order by problem (not sort on cheqno) [message #197582 is a reply to message #197581] Wed, 11 October 2006 22:07 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi
i also had struck with this problem but i found the solution of this problem by the following way.


1. i drag the column at start of group where it exists

my suggestion is

open data model

then you will find cheque_no at the second number

drag it to the first

before description

it will not disturb report formating.


i hope this is the solution of this problem.
reply me if any query

regards

Muhammad Shahid Mughal
Re: report order by problem (not sort on cheqno) [message #197586 is a reply to message #197582] Wed, 11 October 2006 22:18 Go to previous message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
thank's for your reply

brother i try your idea but no get right result

please give me any other idea

thank

aamir
Previous Topic: Install report server -reports 10g
Next Topic: How do you configure XML Publisher to print
Goto Forum:
  


Current Time: Fri Dec 02 20:28:59 CST 2016

Total time taken to generate the page: 0.10758 seconds