Dimension 1 Filter in Sales Analysis Reports

johanna
johanna Member Posts: 369
edited 2011-01-14 in NAV/Navision Classic Client
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 :)
Best regards,

Johanna

Comments

  • dkone
    dkone Member Posts: 59
    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
    johanna Member Posts: 369
    Hi dkone,

    Thank you for your suggestion :)
    I'll try it first :)
    Best regards,

    Johanna

Categories