Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I can find that there are some values are missing in the list box.
Especially null values (-------) while I was using the section access strict exclusion.
how can I aviod this it spoils the whole look and feel.
Regards,
Sundar
Hi,
Can you post an example of what you mean, i.e. a before and after?
I think from the description people are only seeing what selectors they can access via the set up of the section access. As far as i am aware that is how section access works when reducing the data.
An option could be checking peoples access on individual charts and objects and not reducing the data, but it can be a lot of work.
Mark
By using section access with strict exclusion a user could only see/access data to which he/she is associated to and I think this isn't possible with NULL even if you used a star is *; wildmatch - it will be applied only to real values.
This meant you need to fill NULL with real values, maybe like:
if(len(trim(YourField))=0, 'NULL / Missing Values', YourField)
More to NULL could you find here: Finding NULL.
- Marcus
You can do at script level for that list box field like:
if(len(trim(FieldNAme))>0,'FieldNAme') as FieldNAme