locked
Making a 2x2 matrix RRS feed

  • Question

  • I have report in which I am getting the columns returned in the form 

    1

    2

    3

    4

     

    I want to show it like 

    1   2

    3   4

     

    like  a 2x 2 grid. Is it possible in ssrs 2008 R2???

    Tuesday, December 6, 2011 2:29 PM

Answers

  • Look at these examples:

    http://msdn.microsoft.com/en-us/library/cc627441.aspx

    http://msdn.microsoft.com/en-us/library/ms157334(SQL.100).aspx

    for example, assume you have a select statement

    select salesperson, region, salesvalue, percentagesales from sales

    in the datset, you get SalesPerson, region, salesvalue

    add a matrix to a blank report, add the dataset.

    Drag the field salesperson to the row header

    drag region to column header

    drag salesvalue to cell

    You can drag percentagesales too if required.

    You will get a matrix. This is like a pivot table in SSAS and excel.

    • Proposed as answer by Sharp Wang Thursday, December 8, 2011 2:24 AM
    • Marked as answer by ADARSH JAISWAL Thursday, December 8, 2011 9:27 AM
    Wednesday, December 7, 2011 8:21 PM
  • Hi,

    Please try below steps</br>
    1. Take one List on report -> Goto Properties -> DatasetName -> Select your dataset </br>
    2. Right Click List -> Row Group -> Group Properties  -> Add Group using Expression as =ceiling(rownumber(nothing) / 2) </br>
    3. Add Matrix inside list. </br>
    4. Select your field in Column. </br>
    5. Hide first column and second row in matrix </br>
    6. Resize matrix so that it will occupy all space inside list. </br></br>

    Hope this helps.

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Marked as answer by ADARSH JAISWAL Thursday, December 8, 2011 9:27 AM
    Thursday, December 8, 2011 6:49 AM

All replies

  • It is possible. You can use the Matrix data region. For this, you should be able to distinguish the data into two columns.
    Tuesday, December 6, 2011 4:06 PM
  • Hi,

    Thanks for the quick response.

     

    Can you please give me an illustration? 

    Wednesday, December 7, 2011 6:12 AM
  • Look at these examples:

    http://msdn.microsoft.com/en-us/library/cc627441.aspx

    http://msdn.microsoft.com/en-us/library/ms157334(SQL.100).aspx

    for example, assume you have a select statement

    select salesperson, region, salesvalue, percentagesales from sales

    in the datset, you get SalesPerson, region, salesvalue

    add a matrix to a blank report, add the dataset.

    Drag the field salesperson to the row header

    drag region to column header

    drag salesvalue to cell

    You can drag percentagesales too if required.

    You will get a matrix. This is like a pivot table in SSAS and excel.

    • Proposed as answer by Sharp Wang Thursday, December 8, 2011 2:24 AM
    • Marked as answer by ADARSH JAISWAL Thursday, December 8, 2011 9:27 AM
    Wednesday, December 7, 2011 8:21 PM
  • Hi,

    Please try below steps</br>
    1. Take one List on report -> Goto Properties -> DatasetName -> Select your dataset </br>
    2. Right Click List -> Row Group -> Group Properties  -> Add Group using Expression as =ceiling(rownumber(nothing) / 2) </br>
    3. Add Matrix inside list. </br>
    4. Select your field in Column. </br>
    5. Hide first column and second row in matrix </br>
    6. Resize matrix so that it will occupy all space inside list. </br></br>

    Hope this helps.

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Marked as answer by ADARSH JAISWAL Thursday, December 8, 2011 9:27 AM
    Thursday, December 8, 2011 6:49 AM