How to limit Parameter values based on Crystal user

[mynameant]

Hi all, I am using Crystal Reports XI [BEXI] and a report I currently has, is using a parameter [from a view, dynamically] and when a user selects on the parameter, it displays all the values [same for every user]. Now, Depending on the user logged in, is there any way I can restrict values in parameter? I have designed a View based on values in my Database [Oracle] and made sure i have all the crystal users in that view. now, If I log in, can I check in that view and based on my user name, I'll have to pull only a limited rows into parameter list. This way I can filter out unwanted options in parameters for different users.

Any way to do this?