Row-Level Security: Value

The value for Row-Level Security can be one of two types.  It can be a value entered or it can be a token for the UserID.

User Entered

Enter the value used to perform the data selection for row security using the table and column. Follow Crystal formula syntax. For example, character strings need to be enclosed in quotation marks and numbers do not.

UserID Token

If the user selects the UserID option they will be presented with a dropdown if the 5 UserID tokens.  Using the UserID token will substitute the users UserID information when they run the report.  These values are entered for the user when adding a user.  More information can be found in the Users section on how to add the UserID information to a user.  You can also view training videos on using the UserID Tokens on the Ripplestone website

The UserID tokens do not work in the scheduler because there is no logged on user in the scheduler.