If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Radio button and text box

Started by brandi, 04 Oct 2007 01:49:22 PM

Previous topic - Next topic

brandi

Hey Folks

I have a question . I need to create a prompt page which has the following:

<radio button> Enter Last name     <text box>
<radio Button > Enter Gross Amt    < text box>

So they have the choice of selecting one or the other options, and when they do , they have to type it in.

I founda document which got me half way there. Doc 1028713.1 on the cognos supported website.

The part that I'm stuck with is : How do I get the text box to associate with the radio button option that is selected? Do i literally add a text box prompt, and associate it to the value? Is that it that simple? Right now, I Have both radio options... and I created 2 detail filters that look like this :

#prompt('<Last Name>','token','[Last Name]')#

Any thoughts would be great. If there are examples out there, that would be helpful

Amanda

rockytopmark

In effect you will have 2 prompt variables, one for the type and the other for the entered value.  I am not sure why you need 2 text boxes.

1. Create the Radio Check Boxes to designate the Type as you have.  Set to TypeParm
2. Create just one text box for the entry of the desired filter value.  Set to ValueParm

In the Query, create your filter with an If Then Else.

IF (?TypeParm? = 'Name')
THEN ([Last name])
ELSE (cast([Gross Amt],char)) = ?ValueParm?


hth.... Mark