Report Help -Windows OS Count

[PapaTuck]

Hi,

I am using the following report to get the total OS count by Windows version.

The SQL query is set to only display "Active" devices. However, when clicking on the totals, the list expands and there are both, "Active" and "Non-active."

Does anyone have a suggestion to completely hide all of the "Non-active" devices found using this report?

Select Top 1000000 tsysOS.OSname,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tsysOS.OSname
Order By Total Desc

[ErikT · Accepted solution]

@PapaTuck, 

When you click through in the report, you trigger a built-in data object that unfortunately cannot be changed.