Environment: Avalanche Version 6.x, Creating a Custom Report, needing to sort by Folder (Location).
Problem: When not using a "canned" report, needing to create a Custom Report, there is not an option to select a Group Location (Folder).
Cause: Not being able to choose a canned report.
Solution/Workaround: When creating a custom report, you will need to choose a "Property" that is unique to the Folder (Location) that you want in the report.
An example to this would be the "Criteria" that is being used as the Folder Criteria, or even a unique Terminal ID.
Here is an example of the query.
In this query, we have also added a sort by the Terminal ID. This is what the Report would look like.
You can use this query and change the "Where" to another Folder's (Location's) criteria.