I have a report that is used by 5 different groups, lets call them group1, group2, and so on. My data in the report contains aggregated information about all the groups. Group 1 needs to see limited data for everyone else with all data for group1, group 2 needs to see limited data everyone else with all data for group2, and so on. My brain is melting a little with how to do this. My current section access is using a column called PracticeNM and just showing 100% of each groups data and none from everyone else. For the record I am also using ACCESS and NTNAME in my section access section of the script. Can I add another column to base security off of? I hope my question makes sense. I'm happy to post sections of my script if it helps.
