View selection formula 1

Hi Friends,

I created a monthly account statement (Document) for each branch in our company. I need to restrict each branch staffs to view only their branch report. Say for example, if they open the database, in the default view they should be able to see only their branch report even though the view contains the all branch reports.

To do this, when I create the report for each branch, in a special hidden field, I add all the user’s names whoever can view this document (Branch staff’s names). In view selection formula window, I enter the following formula

SELECT (@Contains (<Hidden Filed Name>; @UserName))

The application should check the current user name with the hidden field which contains the names and if the current user name available in that hidden field, that document should show in the view.

But it doesn’t work like this. Actually the document doesn’t show in the view even though the current user’s name is available in the hidden field. I’m using Lotus Notes R5.

Is anyone having any idea why it doesn’t work or any other way to handle this problem?

Any help you can provide would be appreciated.

Thanks.