I've used SSRS in the past, and here it was simple to group together details data with a "group by" clause.
This is very different i TRS, and I'm stumbling on how to do it. Apparently "groups" in TRS is all about showing things grouped, not about aggregating.
I have a database view that offers all details, and I have a single report parameter to filter the view (based on a single comparison).
I want to group together the details rows based on 4 keys, having the rest of the fields being SUM()'d or aggregated by other aggregate functions.
How do I basically do that in TRS ? It's not very obvious.
I've tried using Crosstab's, but they just add one table for each original details row.