OraFAQ Forum: Reports & Discoverer » UNABLE TO RUN THE SQL IN REPORT 3.0

Home » Developer & Programmer » Reports & Discoverer » UNABLE TO RUN THE SQL IN REPORT 3.0 (Oracle, 8.1.7,0.0 / Server Manager 3.1.7.0.0 / Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UNABLE TO RUN THE SQL IN REPORT 3.0 [message #479900]

Wed, 20 October 2010 01:00

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi,

I am having the following sql but unable to run in Report 3.0

SELECT LIC_NO, RO_NO, RO_DTIME, HANDLED_BY,ROW_NUMBER()
   OVER (PARTITION BY HANDLED_BY ORDER BY RO_NO) AS emp_id
   FROM mss_veh_input_test;

Report message to a moderator

Re: UNABLE TO RUN THE SQL IN REPORT 3.0 [message #479916 is a reply to message #479900]

Wed, 20 October 2010 04:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't think that your "ancient" version of Reports Builder is capable of handling "advanced" analytical functions (such as ROW_NUMBER).

Perhaps you could try to create a view (in a database; 8.1.7, I believe, handles ROW_NUMBER just fine) and then base your report on that view.

Report message to a moderator