Total/subtotal SQL ROLLUP Question

I am using the SQL GROUP BY WITH ROLLUP PER MS's





http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data01102002.asp





To create subtotals and totals.





The problem is, I want items on every line, like transaction dates, that are neither grouped by or summed. They are just for information only.





ANSI-92 SQL does not allow any column to be selected that is either not grouped on or has an aggregate function performed.





The MS example in the link above works fine, but does not present much data.





If I wanted to sum total orders and each order's subtotal for a given customer, I would also likely want the order date, who the order was placed by, etc. in each line of the report without grouping or summing that extraneous info.





Here is an example of the SQL syntax:





SELECT


CASE GROUPING (companyId) WHEN 0


THEN (SELECT CFP..Company.companyName FROM Company WHERE Company.companyId = Activity.companyId) ELSE 'TOTAL' END AS [Company name],


CASE GROUPING (dateOrder) WHEN 0


THEN (SELECT CAST(dateOrderAS VARCHAR)) ELSE 'SUB TOTAL' END AS [dateOrder],


SUM(transactionAmount) AS [Request amount]


FROM Activity


WHERE DATEPART(year, dateOrder) = DATEPART(year, '2004')


GROUP BY companyId, dateOrderWITH ROLLUP





...





But I want more details.