Please see attached code. It's using NTName and will block out access. I comment this code. Un-comment and reload to see.
Let me know if you have any idea.
SectionAccessSheet.qvw 143.5 K
I used this, no upper and I replaced the field USERID with FIELD (in excel too)
Also in menù --> settimgs --> document properties --> opening I checked Initial data reduction..... and Strict Exclusion
(ooxml, embedded labels, table is Access);
LOAD upper(FIELD) as FIELD ,
(ooxml, embedded labels, table is Page);
Your code is working but I cannot publish this testing qvw to upfront. I got this error:
(2015-11-17 16:06:52) Error: The document failed to open. Bad Username and password is the most likely cause of this problem.
Do you think where I need setup this username and password? Currently, I set myself as admin but I cannot publish.
Thank you very much.