check box choose [message #657317] |
Sun, 06 November 2016 00:00 |
|
Rashaali1
Messages: 5 Registered: November 2016
|
Junior Member |
|
|
hello
I need help
I choose the check box in oracle forms
how can I used it in the report
I mean when check one choose or three it shows in the report the name of the check box for example active or not active
|
|
|
|
|
|
Re: check box choose [message #657573 is a reply to message #657572] |
Tue, 15 November 2016 00:47 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Wait a minute; the way you wrote the initial message, I understood that you want to check (or uncheck) a checkbox directly on a report.
Your previous message, on the other hand, suggests that you are just displaying "yes" or "no", depending on a value stored (by form's checkbox item) into a table column. That's completely different.
Anyway: I'm glad you found the solution. However, you overcomplicated it, as a simple DECODE manages it quite well. So: in report's query you could have used
select decode(state, 1, 'yes', 'no') state_description
from ...
where ...
|
|
|
|
|
|