OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » check box choose (oracle reports builder )

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

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

Report message to a moderator

Re: check box choose [message #657329 is a reply to message #657317]

Sun, 06 November 2016 04:49

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

Senior Member
Account Moderator

Shortly: as far as I can tell, you can't do that.

Report message to a moderator

Re: check box choose [message #657571 is a reply to message #657329]

Tue, 15 November 2016 00:22

Rashaali1
Messages: 5
Registered: November 2016

Junior Member

it is work

I use PL/SQL IF statement

in the form when I use a check box
I choose 1 for yes
and 2 for no

then in the report
I use a function

then i use to_char

for example

x varchar (100);

begin

if :state=1 then
x:=(to_char('yse'));
else
x:=(to_char('no'));
end if ;
return x;
end ;

Report message to a moderator

Re: check box choose [message #657572 is a reply to message #657571]

Tue, 15 November 2016 00:34

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What does mean TO_CHAR(string)?

Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: check box choose [message #657573 is a reply to message #657572]

Tue, 15 November 2016 00:47

Littlefoot
Messages: 21824
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

Code: [Select all] [Show/ hide]

select decode(state, 1, 'yes', 'no') state_description
from ...
where ...

Report message to a moderator

Re: check box choose [message #657574 is a reply to message #657572]

Tue, 15 November 2016 00:51

Rashaali1
Messages: 5
Registered: November 2016

Junior Member

converts a number or date to a string.

https://www.techonthenet.com/oracle/functions/to_char.php

Report message to a moderator

Re: check box choose [message #657575 is a reply to message #657574]

Tue, 15 November 2016 00:54

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

Senior Member
Account Moderator

So, why are you converting a string (because 'yes' is a string) into a string?

Report message to a moderator

Re: check box choose [message #657587 is a reply to message #657575]

Tue, 15 November 2016 03:49

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

As is 'yse'

Why don't you just have the form pass through yes and no and skip the function in the report altogether?

Report message to a moderator

Previous Topic:	Print Field Text in Vertical Direction
Next Topic:	Generate SAVE disabled PDF - ORACLE Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 28 00:27:00 CDT 2025