I have been working on a problem for a while, and despite my efforts I am unable to get a solution working. By using this site (thanks!) I've finally figured out what star (*) really is doing in section access but I digress. Other posts on this site said that if you want all possible values for a reduction field, use blank - this, however, is not working for me. When using blank and attempting to access the dashboard as a user who's reduction field is blank, I am prompted for a login. I am accessing the document as ADMIN1, in this case. It works fine on the desktop, but once I move it to the server it prompts me for a login. When I use star in place of blank, QV does not prompt me for a login and displays the territories as listed in the section access (aka, does what star causes QV to do). Because star is working fine through AccessPoint, and blank is not, I am lead to believe this isn't an issue with it identifying the domain account and more an issue with my section access table being incorrect. In the end, I need certain users to see all values of the reduction field regardless of the other values listed in the section access table.
This is my section access block as I believe it should be to allow ADMIN1 and USER0 to see all possible values for territory:
Section Access; LOAD * INLINE [ ACCESS, NTNAME, TERRITORY ADMIN, MACHINE\QVSERVICE, * ADMIN, DOMAIN\ADMIN1, USER, DOMAIN\USER0, USER, DOMAIN\USER1, PLAINS USER, DOMAIN\USER2, NORTH GREAT LAKES USER, DOMAIN\USER3, SOUTH GREAT LAKES USER, DOMAIN\USER4, NEW YORK USER, DOMAIN\USER5, MID ATLANTIC ];
Here are a few things to note, and a few things I have already tried:
- I changed USER0 to ADMIN access, and not USER as suggested in another thread. That did not solve the problem.
- I tried removing the comma at the end of the line, thinking that it was simply a syntax issue; no dice.
- I tried creating fake users in section access and setting their reduction fields to all possible values for TERRITORY, so that I could use STAR and not BLANK. Poor design/scalability choices aside, this didn't work.
I am on QV10. Is the usage of BLANK in a reduction field a feature of QV11?
Thanks for any ideas/tips/etc!