Hi,
I have this report for showing some details in changes.
Is it possible to show the users Fullname from tblUsers?
If I add the table tblUsers and select Fullname to be shown, the report has multiple lines from the same user but some other entries are not shown anymore.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetUserRelations.Username,
tblAssetUserRelations.Lastchanged,
tblAssetCustom.Custom1 As Inventarnummer,
tblAssetCustom.Custom2 As Kostenstelle,
tblAssets.Description,
tblAssetCustom.OrderNumber,
tblAssetCustom.Serialnumber,
tblAssetCustom.Location,
tblAssets.Firstseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetUserRelations On tblAssets.AssetID =
tblAssetUserRelations.AssetID
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssetUserRelations.Lastchanged Desc
