SQLTeam.com | Weblogs | Forums

SSRS Column grouping


I have a ssrs report that looks like the following ( I guess a picture is more worth) :

I want to filter the column Datum for a certain year. I also want to add another two columns for a different year (one column for the datum and one for the suiker for that year.

The table is already grouped as you can see - I want to retain this grouping, but also add a column group for the different years. I am using SQL server. Should I rather do it in SQL (and how?)