Reports - Limit Grants to User Viewing's Office

Possibly useful if replacing the grant list view on the grant section front to limit user's ability to view/click into grants that are not part of their office or program.

Grant > Assigned Offices (one per row) > Office > Name

AND

Grant > Office > Name

Both fields automatically add a filter that gives you the "Is the User Viewing the Report" option. Refresh the page if you don't immediately see the filter.

Notes:

If a grant is not assigned to an office, it will not be returned in this report.

You must also use one of these fields on the grant create or edit process to assign the grant to an office.

If you are using the "additional offices" user field, this filter will match on additional offices as well.