I want to be able to show a report with groups that have more than one of an asset. In SQL Server I would do it with a query like this:
Select AccountID, Count(AssetID) From Assets Where AssetName Like 'My asset' And Count(AssetID) > 1 Group By AccountID
Which would only return the Accounts that have more than 1 of that specific asset.
I can do all of that in report builder in an an "Accounts with Assets" report, except for the Count(AssetID) > 1 part.
Is that possible?
I would love to avoid having to scroll through several thousand rows looking for the few that got doubled up in the data import.