Dimension 1 Filter in Sales Analysis Reports

johanna

Dear all,

I have used security filter on Dimension Value table for user A so in the Form Analysis Reports of Sales & Marketing, this user only lookup one Dimension Value for Dimension 1 Filter. But, if this user enter other value (not lookup), the Dimension 1 Filter can be filled with entered value, although this user has no permission to enter this value. How could this happen? Any idea to solve this matter? Thanks before

dkone

Hi,

Maybe you could put some code like this in the 'On-Validate' trigger

YourRecord.SETPERMISSIONFILTER;
YourRecord.SETRANGE(Code,Code)
IF NOT  YourRecord.FINDSET THEN ERROR('Not allowed');

Hope this helps,

dkone.

johanna

Hi dkone,

Thank you for your suggestion
I'll try it first