Section Access Does Not Select the Reduction Value

[Anonymous]

I have the following code for the Section Access in Edit Script.  I am not getting any of the values for the PB_Charge_CostCenterNamethe such as Cardiology to be selected upon logging in as Mickey or anyone in the code (Minnie, etc).  None of the

[fPB_Charge]:

load

  CostCenterName AS PB_Charge_CostCenterName

;

sql select

  CostCenterName

from DW.cfn_Lookup_PB_Charges_Staging()

;

SECTION Access;

Authorization:

Load * Inline

[Access, Userid, Password, fPB_Charge.PB_Charge_CostCenterName

ADMIN, QTRAN, PASS1,

USER, MICKEY, PASS1, CARDIOLOGY

USER, MINNIE, PASS1, ENT

USER PLUTO, PASS1, GASTROENTEROLOGY

USER PLUTO, PASS1, ALLERGY CLINIC

];

[Anonymous]

The fPB_Charge.PB_Charge_CostCenterName does not contain any selections when I log in using the above accounts such as Mickey.  I have also tried just with PB_Charge_CostCenterName and that did not work.

[Anonymous]

I added a comma after user and pluto (user, pluto) but I still have the problem of not getting anything selected for the PB_Charge_CostCenterName listbox

USER PLUTO, PASS1, GASTROENTEROLOGY

USER PLUTO, PASS1, ALLERGY CLINIC

[Anonymous · Accepted solution]

I capitalized CostCenterName using upper(CostCenterName) and it now works.