SSRS Matrix report question

Posted by Sravanthipavan under Sql Server on 4/11/2014 | Points: 10 | Views : 553 | Status : [Member] | Replies : 2
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




Responses

Posted by: Bandi on: 4/16/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down

Refer this link...

http://stackoverflow.com/questions/10954323/trying-to-add-sub-row-group-inside-parent-but-flush-left-in-the-nested-cell

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sravanthipavan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 4/16/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
refer
http://www.sqlservercurry.com/2011/03/sql-server-reporting-services-tutorial.html

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sravanthipavan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response