If anyone wants a group category tag cloud you can make one with a module like ActiveHTML or the DNNSTuff SQL module (and maybe the core Reports module - I have not used it).

You can see the end result on the right of my poker groups page.

Here is the SQL:

DECLARE @MaxScore INT
SELECT @MaxScore =
(
SELECT Top 1 Count(CategoryID) As Score
FROM activesocial_Groups G
INNER JOIN activesocial_ItemCategories GC ON GC.ItemID = G.GroupID
WHERE G.PortalID = 6 AND AccessType = 0
GROUP BY GC.CategoryID
ORDER BY Score DESC
)
SELECT GC.CategoryID,
C.CategoryName AS Category,
1 + (Count(GC.CategoryID) / (@MaxScore / 4)) AS Score
FROM activesocial_Groups G
INNER JOIN activesocial_ItemCategories GC ON GC.ItemID = G.GroupID
INNER JOIN activesocial_Categories C ON C.CategoryID = GC.CategoryID
--public
WHERE G.PortalID = 6 AND AccessType = 0
GROUP BY GC.CategoryID, C.CategoryName
ORDER BY C.CategoryName

Hi Rodney,
I have used dnnstuff sqlview free edition but I don't be able to set the module (grid settings, grid styles, sorting, paging).
Can you help me?
thanks