I'm trying to create a sales report by territory in the Report Designer.
I've read the row-level security help. It states that to use the getuserID function you must you report modeling. Is this true first of all and secondly, if not can someone explain very easily how I can restrict sales detail records in a report to the territory that is responsible for it...
I want to use the report design tool and publish to reporting services.