| ROW NUMBER IN REPORT WRITER [message #190255] |
Tue, 29 August 2006 21:48 |
kumarvk
Messages: 214
Registered: July 2004
|
Senior Member |
|
|
Hi All,
I am using the following query in my report builder but it gives me REP-0496 Internal Error-Unable to parse the query.
My query is this
select row_number() over (order by 2) "SNO",A.cont_no "CONT NO",to_char(A.cont_date,'DD-MON-YY') "CONT DATE",
to_char(a.cfm_date,'DD-MON-YY') "CFM DATE",f.short_desc model,
substr(decode(a.eng_co_name,'',a.eng_first_name||','||a.eng_last_name,a.eng_co_name),1,40) "CUSTOMER NAME",
c.SHORT_NAME SALESMAN,A.TCOE_AMT "TCOE"
from cch a, ccc b,cau c,ccm d,csm e,cdm f
where A.ref_no = B.cthd_ref_no and b.ccoe_coe_id IS NULL and A.APUR_ID_SM=c.APUR_ID and a.sales_type <> 'E' and a.ref_no=d.cthd_ref_no and d.subm_id=e.id and e.dchm_id=f.id
and d.cancel_flag='N'
Can anyone help me this regard?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
