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.
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.
Just a small correction instead of '?Parameter1?' just drag the Parameter1 it will be somewhat like this:
ParamDisplayValue('Parameter1')
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.