Report "filtern"

voc

good morning everyone

i have the following problem: if a report starts, i want that all concerning lines are filtered, so that every user can only see the lines, he is allowed to see... but we don't wana modify every single report and so my question is, if there is a solution for this problem... the user doesn't have to enter any filter and so it's not possible to manage it with an OnValidate-trigger of one of the fields...

thanks in advance!

claus

garak

Dear claus,

1. please don't write here in german, use english.
For german questions, please use Timos site -> MSDynamics.de.

2. Answer to your question:
How do you know, which lines the user can see :?:
Do you store in every line the userid :?:

voc

oh, i'm very sorry for writing german...!

no, the userid is not stored in every line... we have some "area-codes" and every user has one or more area codes and every line belongs to an area-code...

thanks in advance!

claus

kine

If you are using MS SQL db, you can use the Security filters, but they are hard to setup and use, and in some situations you still need to add some code...