如何使用SQL Server和Reporting Services使用total和breakout列来构建报表

I have a data structure where I have two tables Alpha and Beta and they are one to many. For the sake of an example let's say that table alpha has a column for "State" and table B has "Colors you like" and you can pick more than one. I would like to build a report that has columns like this:I have a data structure where I have two tables