Report specific domain

[Notonyourradar]

I am not very good at reporting, with that out of the way, I have multiple domains and am looking at how to focus the reports to only report on a specific domain. This is the query I'm using now:

Select Top 1000000 tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  Count(tblSoftware.SoftwareID) As Total
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.SoftwarePublisher Like N'%Adobe%' And
  tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion
Order By Total Desc,
  Software

I'm looking to get a count of Adobe Products by domain, any help would be much appreciated!

[Notonyourradar]

Never mind, I figured it out. Thanks again!

[Notonyourradar]

Thanks! That accomplished what I needed.

Unfortunately I tried to apply this to the OS: Operating System Overview report and have failed ever so miserably. The goal of the report is to report of the count of each OS (2003 standard, enterprise, 2008 std and ent, etc) per domain. If it's not too much to ask could you point me in the right direction?

This is only giving me count by OSname and what I'm really looking for is to get the count by Caption (I guess?)

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

[Hemoco · Accepted solution]

Do the following:
- In the visual representation of the report in the upper section of the report builder, tick the Domain field in tblAssets to add it to your report.
- In the expression list, tick the Grouping checkbox for the tblAssets.Domain expression.
- Select For Groups in the Criteria For column for the same expression.
- Hit the Save & Run button.