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
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