-SET &&USERID = CNCTUSR('A50');
-SET &&USERID = TRUNCATE(&&USERID);

  
USER=X, ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=somefieldinmydatabase = &FOCSECUSER.QUOTEDSTRING;

quote:

Originally posted by eric.woerle:
Mike

You don't want to use &IBIMR_user variable because that gets set by the client through the Custom Settings. What this means is that anything that does not come in through the client won't have that value set. In version 8.0.08 things like Report Caster don't come in through the client (IBI has mentioned that in the future they will change this, because your Site Profile also doesn't run when using ReportCaster, but I don't know which version that change has/will occur). RC connects directly to the Reporting server so the variable &IBIMR_user never gets set.

The current recommended variable to use according to the IBI documentation is &FOCSECUSER which gets set by the Reporting Server. this is recommended over the GETUSER and CNCTUSR subroutines

Also I wouldn't put your value in quotes. I would use .QUOTEDSTRING instead. I always use .QUOTEDSTRING when evaluating my variables. Its cleaner and handles issues like what your experiencing

  
USER=X, ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=somefieldinmydatabase = &FOCSECUSER.QUOTEDSTRING;