cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
fpd2dc
Engaged Sweeper II
Good Morning
The SQL below was copied from the edit screen of a custom report I wrote. The report works with the exception of the location field. These assets are located in vehicles and I have added them as locations on their asset page. I just can not get the report to display the text.

I must have the wrong field in the select statement.

Thanks for any assistance.

Bruce





Select Top (1000000) tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.Username,
tblAssets.Description,
tblAssetCustom.Location,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'rugged laptops' And tblAssetCustom.State = 1