I would like to know if is possible to have two or + Colums of software where displaying just the software choosing in each column, at this moment this is the querty that I have.
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tblassets.Username,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassetcustom.Location,
tblSoftwareUni.softwareName As [Software 1],
tblSoftwareUni.softwareName As [Software 2],
tblSoftwareUni.softwareName As [Software 3]
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblSoftware On tblassets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tsysassettypes.AssetTypename Like 'windows'
At this moment this is what I get when I run the report is showinme the same
