Hi,
I've searched the forums and haven't found and answer so I'll give posting a go. I've set up a report which I hoped to show the comments from each server, even when blank. The report runs and shows only the servers that have the comment field populated.
I have a feeling that tblAssetCustom.State is where I need to make the change, anything other than "1" causes the report to fail or returns no results.
the report code is below:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetComments.Comment,
tblAssetComments.AddedBy,
tblAssetComments.Added
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Where tblAssetCustom.State = 1
Thanks for your help,
-Andy
