Report Builder shows multiple entries for each machine. How to get report with one machine per row

[psaini]

Hello!

I am trying to create a report. The query works fine except that the report comes with multiple entries for every machines. I have more than 1000 machines. How can I get the repiort builder to generate to show all requested data for one machine per row.

Query is as below:

Select Top 100 Percent dbo.tblComputers.Computername,
dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged,
dbo.tblComputersystem.TotalPhysicalMemory, dbo.tblComputersystem.SystemType,
dbo.tblComputersystem.Roles, dbo.tblComputersystem.PrimaryOwnerName,
dbo.tblComputersystem.NumberOfProcessors, dbo.tblComputersystem.Model,
dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Description,
dbo.tblComputersystem.CurrentTimeZone, dbo.tblComputers.Username,
dbo.tblComputers.LastActiveScan, tblBattery.DesignCapacity,
tblBattery.DesignVoltage, tblBattery.Availability, tblDiskdrives.DriveType,
tblDiskdrives.Freespace, tblDiskdrives.Size, tblNetwork.MACaddress,
tblNetwork.IPSubnet, tblOperatingsystem.FreePhysicalMemory,
tblOperatingsystem.OSLanguage, tblPhysicalMemory.PositionInRow,
tblPhysicalMemory.MemoryType, tblPhysicalMemory.Speed,
tblPhysicalMemory.Capacity
From dbo.tblComputersystem Inner Join
dbo.tblComputers On dbo.tblComputersystem.Computername =
dbo.tblComputers.Computername Inner Join
tblBattery On dbo.tblComputers.Computername = tblBattery.Computername
Inner Join
tblDiskdrives On dbo.tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblNetwork On dbo.tblComputers.Computername = tblNetwork.Computername
Inner Join
tblOperatingsystem On dbo.tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblPhysicalMemory On dbo.tblComputers.Computername =
tblPhysicalMemory.Computername
Where dbo.tblComputersystem.Domainrole < '2'

[Hemoco]

Short answer: you can’t.
Some tables will only have one record (tbloperatingsystem,tblcomputersystem,…) these tables can be used to output only one line.
Other tables like diskdrives,network can contain multiple rows because you can have multiple disks or network cards.