We have a report where some users may have multiple choices on the prompt page but others would only have one choice. This is all controled by security in their user setups. What we would like to do is if a user only has once choice, then that one prompt would be hidden from them and they would only have the other prompt that would be for a date range to choose. Other users would have the two prompts. Would appreciate any help on how to accomplish this. Thanks
i think you can accomplish this with javascript in you report. :-\
check if there is only one prompt value returned. If so do not show the prompt but use the value to filter the report.
Thank you, we will give that a try.