Filter Reports based on User Setup

pengweninc

I don't know where they went, but I've lost what little programming skills I had... ](*,)

I've added a field to the User Setup called "Salesperson Filter'. I've successfully used this filter when opening forms:

OnOpenForm
IF UserMgt.GetSalesUserFilter() <> '' THEN BEGIN
FILTERGROUP(2);
SETRANGE("Salesperson Code",UserMgt.GetSalesUserFilter());
FILTERGROUP(0);
END;

Now I want to apply this same filtering logic to a couple of reports, Customer - Order Detail, Customer - Sales List, etc. I am totally drawing a blank.

By the way, this is not SQL so I can't use the Security Filters

Thank you!

kriki

In the OnPreDataItem() of your dataitem, you can put the same code:

IF UserMgt.GetSalesUserFilter() <> '' THEN BEGIN
  FILTERGROUP(2);
  SETRANGE("Salesperson Code",UserMgt.GetSalesUserFilter());
  FILTERGROUP(0);
END;

The filtergroup serves in this case to avoid that you overwrite the filter set by the user (if the user wants to filter by "Sales person").

pengweninc

Wow! I lost my marbles and you helped me find them.

Thank you!