Filter on a Value Prompt

[akhattri]

Hi All,
I have report requirement where the user wants to view only certain values on the prompt to be displayed. i.e. If I have values A,B,C,D,E,F for a column in a table, the user wants to see only values A,B,C on the Prompt to be displayed and then make his selection out of those and the report should filter based on those. How is it achievable?

Thanks!

[nfldbunker]

HI

I have a similar report request where i have maye 1000 codes and associated descriptions  in a table but only want the users to be able to select in the prompt maybe 100 of those codes and desc.

let me know how you make out ..my post if the first at the top of the report section

[Gopinath]

Add a filter in your prompt query(Query associated to your value prompt) to restrict the value displayed in your prompt

[kalyan_y]

Create user groups and apply Object level security(Security Filters) at FM level on the query subject for which you want to display the data based on the user logged in.

[akhattri]

Thanks Gopinath! Yours is the solution I was looking for.

Kalyan, thanks for your input also, but we did not want to implement security.