How to make a data item with a prompt in it optional??

[dcognos1178]

All -
I have a report that I have a data item where based off of one prompt value is how I want the report to behave. So like this (I know code is wrong...that is what i need help with)

IF (ParamValue (date choice) = ‘relative’)
Then IF ([Finish Time] between _add_days (current_date,-1*(?day offset?)) and current_date )
THEN (1)
ELSE (0)
ELSE IF ( ParamValue(datechoice) = ‘range’)
THEN IF ([Finish Time] > ?Begin Date?
AND
[Finish Time] <= ?End Date?)
THEN (1)
ELSE (0)

So the prompt ?day offset?, ?Begin Date?, and ?End Date? should be optional based off of the ParamValue(datechoice). This is put directly in the list as a value. So I need to know the best way to accomplish this.

Any help would be greatly appreciated - let me know if you need more info.

 

[drlex]

If you were using Impromptu, I would suggest cascading prompts (see Help page).

soi là, soi carré