on the basis of selection need to display date prompt

[everlearner]

Hi Gurus,

my req is, user has to select/enter either start or end date ( date should be in range).

i have taken a value prompt with 2 options, when he select  start ,then i have to display start date prompt ,
when he select end, then need to display end date prompt in the same page.

my question is when user select a option from value prompt, how can i show  date prompt automatically? or after selection need to put any button to show date prompt?


how can do this? can any one help me in this regard.

[hemantsoni]

Hi,
After you add all the prompt to your prompt page define a string variable.
If '?parameter1?'='Start' then 'start'
else
'end'
where parameter1 is the parameter of the date prompt

Add two values for your string variable:start and end then render the prompts using render variable.

You can also set box type='None' for the prompts.

Same thing can be achieved using a  case statement.
You can also use a Boolean variable.

[hemantsoni]

Just a small correction instead of '?Parameter1?' just drag the Parameter1 it will be somewhat like this:
ParamDisplayValue('Parameter1')

[bi4u2]

Everlearner, you do not need two parameters, you can structure the filter in the query like this: Date in_range ?pDateRange?, by using the range properties it will display 2 data prompts.