I am trying to create a matrix report in SSRS using Visual Studuio 2008 . My reports are .rdlc reports This is how I want the report look like
Product Name |Year | Question1| Question 2| so on........ Test 1 |2012 | Response1| Response 2| so on........ Test 1 |2013 | Response1| Response 2| so on........
But my report comes as like this
Product Name | Question1| Question 2| so on........ Test 1 |2012 | Response1| Response 2| so on........ |2013 | Response1| Response 2| so on........
I am not able to achieve this the year column is adding a sub group but not as a seperate column
When I right click on the Product Name row these are the options i get though
Let me know if any other option i have .
Thanks , Sravanthi