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
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