I would like to filter a "radio button group" prompt depending on the user logged in. For example, assume a radio button prompt exists with three options (state, county, town). If UserA is logged in, I want all three options to display (i.e., state, county, town). If UserB is logged in, I want just the first two options to display (i.e., state, county). Additionally, I would like to extend this functionality to "anonymous" users. Using the same radio button example, if an anonymous user is running the report, I want just the first two options to display (i.e., state, county).
Thanks in advance for your help.
One way is you could use data security feature, which would implement a filter on a query subject based on a condition, logged in user. You can then use the relevant field from the query subject in the prompt.
Thanks for the quick response. Can this be implemented at the report level or does this have to be at the FM model level?