OraFAQ Forum: Reports & Discoverer » How to use LAG function in Oracle Reports 6i?

Home » Developer & Programmer » Reports & Discoverer » How to use LAG function in Oracle Reports 6i?

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

How to use LAG function in Oracle Reports 6i? [message #423025]

Mon, 21 September 2009 19:56

radhavijaym
Messages: 65
Registered: December 2008
Location: singapore

Member

Hi,
can any one help me how to use lag analytical function in oracle reports 6i.

Report message to a moderator

how to use lag function in oracle reports 6i [message #423028 is a reply to message #423025]

Mon, 21 September 2009 20:00

radhavijaym
Messages: 65
Registered: December 2008
Location: singapore

Member

Hi,
can any one help me how to use lag analytical function in oracle reports 6i.

syntax of lag:

lag(expression,1,0) over (order by expression)

please help me its urgent

thanks,
radha

Report message to a moderator

Re: how to use lag function in oracle reports 6i [message #423107 is a reply to message #423028]

Tue, 22 September 2009 03:19

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

Senior Member
Account Moderator

If you have used a correct syntax but it doesn't work, then perhaps Reports 6i engine doesn't know LAG (i.e. is "too old").

Report message to a moderator

Previous Topic:	LAG Calculation
Next Topic:	Four different columns as one column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:35:01 CST 2024