→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
soma
Engaged Sweeper
There is a report as mentioned in the title.
No i want to modify it so i can filter it by location.
does anybody has a clue how to do that?
I am pretty knew to ls and this query stuff.
thank you for your answers.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
We're not sure which location field you're referring to. If you're referring to the "custom" location field, stored in the same table as the Custom1-Custom20 fields:
- Double-click on tblAssetCustom in the table list on the right, if the table is not yet part of your report.
- In the visual representation of the report in the upper section of the report builder, tick the Location field in tblAssetCustom.
- You can then run the report and filter the location within the report results.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
We're not sure which location field you're referring to. If you're referring to the "custom" location field, stored in the same table as the Custom1-Custom20 fields:
- Double-click on tblAssetCustom in the table list on the right, if the table is not yet part of your report.
- In the visual representation of the report in the upper section of the report builder, tick the Location field in tblAssetCustom.
- You can then run the report and filter the location within the report results.