Home » Developer & Programmer » Reports & Discoverer » ROW NUMBER IN REPORT WRITER
ROW NUMBER IN REPORT WRITER [message #190255] Tue, 29 August 2006 21:48
Messages: 211
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",
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?
Previous Topic: Problem with PageItems
Next Topic: Run Report With Host Proc
Goto Forum:

Current Time: Thu Aug 24 03:54:41 CDT 2017

Total time taken to generate the page: 0.01900 seconds