This is a modification of the default report Compliance 5 – Specific Computer, but it combines the result for each computer in a collection. The report can get quite long, however, it is a much better than running the default report for each computer in a collection, exporting the data to Excel, and manually combining it.
The report file (Compliance 5 – Computers in a Collection.rdl) can be found on my GitHub repo.
Perry Smith gets the kudos for twisting my arm enough to develop the report. Actually it was a lot easier than I anticipated.
Kudos also go to Garth Jones for his post on @UserSIDs which is tremendously helpful in using Microsoft SQL Server Management Studio for T-SQL development of SQL Reporting Services reports.