Computer Overview Report w/ Chassis

[chads]

Looking to copy the Computer Overview report but add the chassis type column to it. been trying to add it but can't figure it out any help here.

[chads]

Thank you! see what i did wrong

[RCorbeil · Accepted solution]

Make sure your table selection includes tblSystemEnclosure and TsysChassisTypes.

Linkage:
tblAssets -> tblSystemEnclosure -> TsysChassisTypes

  Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes

Once you've got that, the description of the chassis is TsysChassisTypes.ChassisName.