Oracle reports bulider cannot use CASE WHEN statement 1

[soushi01]

Hi, all

Just want to ask that is it oracle report cannot using "CASE WHEN " statement in SQL query statement .
Because when i put it , it pop up error message "Unable parse to Query"
Please correct me if wrong

* Note: im using Oracel reports Developer 200 and oracle reports 6i

thanks
regards
Peggy Leong

 

[oradba101]

What is the database version?

William Chadbourne
Programmer/Analyst

 

[soushi01]

Hi, oradba101

im using oracle 9i as database, for report developing tools im using
oracle developer 2000 's report builder and oracle 6i 's report builder

thanks

 

[oradba101]

Hi, Soushi01

Oracle reports earlier than 9i will not recognize CASE statements internally. You could probably get it to work from within the database.

William Chadbourne
Programmer/Analyst

 

[soushi01]

Hi, oradba101

Oh i see, tq so much for ur reply.