using a list-user field to filter a report
Howdy,
I posted recently about a budget app I am working on. I have Areas. Areas have many accounts. Each account can have many categories. Each Area/Account/Category combination can have many expenses. I also have budget administrators. These budget administrators can have more than one area that they are responsible for. I've got the conditional drop downs working so that when a specific area is chosen, based on that area there is a specific list of accounts and based on the area/account combo chosen, there is a specific list of categories to which expenses can be added.
Where I am stuck is that I want my budget administrators to only be able to see and/or edit/add expenses to those areas that they have been "assigned" to. It was suggested that I use a list - user field, which I have done on the area table. The area and the admin flow as a lookup to the Account table and then on down to the Category table as a look up.
When I created the report for the home page and then tested as a user, the report didn't bring in any of the areas and I could see all of the accounts regardless of area. I'm not sure if it's an issue with how I'm creating the filter on the report maybe? I've tried many variations and just can't seem to get it to work.
I've attached a picture of the filter, how I'm grouping the report, as well as the result I'm getting when I go to the home page and test as a specific user. (When I just run the report as a specific user, I get no results).
I thought about basing the report off of the expense table -- but that report will only show me areas/accounts/categories where there is already an expense. I need the report to show all accounts, even if there is no expense yet, so I can add an add expense button. This will make it so that the admin will only see their accounts and when they click "add expense", the correct area will already be populated and kick off the cascading dropdowns for account and category.
Thanks for your help and guidance!
------------------------------
Andrea Johannes
Associate Director
Texas A&M University
------------------------------
I posted recently about a budget app I am working on. I have Areas. Areas have many accounts. Each account can have many categories. Each Area/Account/Category combination can have many expenses. I also have budget administrators. These budget administrators can have more than one area that they are responsible for. I've got the conditional drop downs working so that when a specific area is chosen, based on that area there is a specific list of accounts and based on the area/account combo chosen, there is a specific list of categories to which expenses can be added.
Where I am stuck is that I want my budget administrators to only be able to see and/or edit/add expenses to those areas that they have been "assigned" to. It was suggested that I use a list - user field, which I have done on the area table. The area and the admin flow as a lookup to the Account table and then on down to the Category table as a look up.
When I created the report for the home page and then tested as a user, the report didn't bring in any of the areas and I could see all of the accounts regardless of area. I'm not sure if it's an issue with how I'm creating the filter on the report maybe? I've tried many variations and just can't seem to get it to work.
I've attached a picture of the filter, how I'm grouping the report, as well as the result I'm getting when I go to the home page and test as a specific user. (When I just run the report as a specific user, I get no results).
I thought about basing the report off of the expense table -- but that report will only show me areas/accounts/categories where there is already an expense. I need the report to show all accounts, even if there is no expense yet, so I can add an add expense button. This will make it so that the admin will only see their accounts and when they click "add expense", the correct area will already be populated and kick off the cascading dropdowns for account and category.
Thanks for your help and guidance!
------------------------------
Andrea Johannes
Associate Director
Texas A&M University
------------------------------
