Need to show repeating rows of Order Numbers RRS feed

  • Question

  • User-1210839387 posted

    using report builder 2.0

    I am returning all order numbers in the query attached to my report.

    I would like to display each order number on a new row.

    I did the following steps:

    1.  dragged and dropped a matrix onto my report

    2. dragged the OrderNumber field from my DataSet to the cell in the matrix which now shows

    column header text: "Order Number"

    column expression: Sum(OrderNumber)

    when I run the report as expected it shows the header text and one Summed value of all OrderNumbers.

    How do I change the matrix to show a separate row for each order Number?

    New to these reports here.



    Tuesday, July 26, 2011 9:42 AM


  • User1471008070 posted


    To this requirement of yours, I would recommend you make use of Table rather than matrix to achieve it. If you have any other question, please feel free to ask.

    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 27, 2011 11:22 PM