Home » Developer & Programmer » Reports & Discoverer » How to use LAG function in Oracle Reports 6i?
How to use LAG function in Oracle Reports 6i? [message #423025] Mon, 21 September 2009 19:56 Go to next message
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.

how to use lag function in oracle reports 6i [message #423028 is a reply to message #423025] Mon, 21 September 2009 20:00 Go to previous messageGo to next message
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
Re: how to use lag function in oracle reports 6i [message #423107 is a reply to message #423028] Tue, 22 September 2009 03:19 Go to previous message
Littlefoot
Messages: 20827
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").
Previous Topic: LAG Calculation
Next Topic: Four different columns as one column
Goto Forum:
  


Current Time: Wed Sep 28 05:42:17 CDT 2016

Total time taken to generate the page: 0.38912 seconds