There may be times where the available filters in the Report Center are insufficient. In this case, how to create a custom query?
In the Report Center-More screen, a custom query can be used to filter report data. You will need to know the database table, field you wish to filter and proper values for that field.
A simple query would be {Table.Field}='value'
Example: {Project.ProjectOther2}='36'
In this scenario, the project's Custom 2 field is used for the office location. You can now filter by this field and show only data related to office 36.