case help please

[sonny1974]

i have oracle 9i and crystal xi

this formula works in crystal

if ({Command.RANK}= 3 and previous ({Command.RANK})=2 ) and ({Command.QTY} = {Command.QTY}
and {Command.TRAN_CODE} = '28') or
({Command.RANK}= 3 and previous({Command.RANK})=2 and {Command.TRAN_CODE} <> previous({Command.TRAN_CODE}))then 1

but it wont work in my command statement , when i do a case in sql
can you help me on the coding so it works in my command

 

[JarlH]

I suggest you shold try an Oracle forum instead. They will probably be able to help you with this.