OraFAQ Forum: Forms » check box pass value

Home » Developer & Programmer » Forms » check box pass value

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

check box pass value [message #585876]

Thu, 30 May 2013 10:51

hassan08
Messages: 123
Registered: June 2011
Location: egypt

Senior Member

i ' m created check box on the form
i need when click on check box then
pass this value to report
such as
the value = ' i love oracle developer'
i need when click on this check box this value will be appear on the report

Report message to a moderator

Re: check box pass value [message #585878 is a reply to message #585876]

Thu, 30 May 2013 11:30

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Before passing parameters to the report you can check for the value of the checkbox. Hope this helps

Report message to a moderator

Re: check box pass value [message #585880 is a reply to message #585878]

Thu, 30 May 2013 11:36

hassan08
Messages: 123
Registered: June 2011
Location: egypt

Senior Member

this value will fixed on the report

Report message to a moderator

Re: check box pass value [message #585881 is a reply to message #585880]

Thu, 30 May 2013 11:41

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

I am sorry i wasn't able to understand you.
you can try this
IF :BLOCK.CHK_BOX = 'Y' THEN
ADD_PARAMETER(l_list_id,'P_MESSAGE',TEXT_PARAMETER,'YOUR MESSAGE');
END IF;

You can pass this parameter to your report

Report message to a moderator

Re: check box pass value [message #585949 is a reply to message #585881]

Fri, 31 May 2013 06:06

hassan08
Messages: 123
Registered: June 2011
Location: egypt

Senior Member

i do this steps but now
how can replace the current text existing in report to the text passing in the parameter
such as
the text in report
oracle developer
replace it to
the value passing of parameter
and make this steps dynamic
such as
if the user don't click on check box the text "oracle" will be appear but the user click on check box the value passing of parameter will be appear

Report message to a moderator

Re: check box pass value [message #585950 is a reply to message #585949]

Fri, 31 May 2013 06:13

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

You can write code in Before parameter form or you can handle this in the if else condition in form like

IF :BLOCK.CHK_BOX = 'Y' THEN
ADD_PARAMETER(l_list_id,'P_MESSAGE',TEXT_PARAMETER,'YOUR MESSAGE');
ELSE
ADD_PARAMETER(l_list_id,'P_MESSAGE',TEXT_PARAMETER,'oracle developer ');
END IF;

Report message to a moderator

Previous Topic:	ORA-29283: invalid file operation
Next Topic:	Uploading an excel file using webutil in AIX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 09:24:54 CDT 2025