SELECT ISNULL(CAST(A.TopicID AS VARCHAR(2000)), [Report Total:]) AS [Conference] ,
ISNULL(A.TopicName, '') [Topic Name] ,
COUNT(*) AS [Number of Entries] ,
SUM(A.Amount) AS Sum
FROM vwApplication A
INNER JOIN Topic B ON A.Topic = B.Topic
INNER JOIN ConfCity C ON B.ConfCityFK = C.ConfCityKEYID
WHERE MoneyReceived = 1
AND Amount > 0
GROUP BY (A.TopicID , A.TopicName) /* small tweak */
WITH ROLLUP
Open in new window
Open in new window