I'm working on a report that shows mobile phone numbers and links them to the departments in our organisation.
I've gotten everything in place and all is working.
The problem arrises when I start using data reduction with Section Access. Im using data reduction based on the organisational units (OE) (a number)
Users can only see the phone numbers that belong to their own OE. I got everything set up, even the users that have an exception to this rule (some users are required to see all phone numbers).
Now the problem:
Because restrictions are given on OE level, phone numbers that are not linked to persons can't be viewed. I see them when reloading, but after saving and reopening the data reduction is effective and I lose those numbers.
How can I make these numbers without a person linked to them visible to some users?
1. Phonenumbers (Link to persons is right(phonenumber, 8))
2. Persons (Link to OE_LINKTABLE is PERS_NR)
3. OE_LINKTABLE (Link to OE is OE_NR)
Data reduction is taking place on table 3 (OE_LINKTABLE) on OE_NR_2 (I made a second key for this link, but the value is the same as OE_NR)
If you need more info please ask. I'll be going home now, but will be answering and viewing this topic tomorrow.
P.S. I can't upload the QV report as there is sensitive information in it.