I have created a report that shows all programs and the budgets associated with all programs and it works fine. Now, I am trying to create a report that does the same but only show the programs that are associated with a specific program manager. The only filter available to me is program owner ID. I would assume that is the correct filter. Issue is, it is not doing what I need. When I use that filter and run the report, I get only 4 selections. When I take the filter off, I get 13.
And, when I log in as a user who should only see 2 programs because they are the program manager for those 2 programs, they see the original 4 that I also see even though I am not the program manager for any programs.
In fact, when I log in as any of the program managers, they all see the same 4 and not the ones they own even when I specify the filter as program owner ID - $$USER.ID.
All thoughts are welcome.