To add your assets' IP locations to a report, do the following:
Hit the pencil shaped edit button next to the report under Reports\View All Reports.
In the search bar in the left-hand pane. Search for IPlocation.
Double-click tsysIPLocations to add it to your report.
Right-click on the link between tsysIPLocations and tblAssets, configure the link as shown below.
Tick the IPLocation field in tsysIPLocations to add the field to your report.
Hit Save & Run to save your changes and view the report results. The final link between tblAssets and tsysIPLocations should look like this within your SQL query:
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID