SSRS 2005: Matrix Control with Multiple Columns (But NOTNested) -
05-22-2009
, 11:05 AM
Hi,
I need to create a tabular report using the SSAS 2005 cube that has multiple
Dimension as Columns and Rows, but NOT Nested.
i.e.,
Quad Gender
Favorite Color MU25 MO25 FU25 FO25 M F
- Red 25% 30% 3% 40% 50% 60%
- White 50% 65% 77% 50% 40% 30%
- Blue 25% 5% 20% 10% 10% 10%
Favorite Transport
- Car 90% 70% 80% 80% 90% 85%
- Bike 10% 30% 20% 20% 10% 15%
What is the best way to do this in SSRS 2005?
Thanks in advance!
Jason |