Last post Jul 27, 2011 11:22 PM by You-Hu Fu
Jul 26, 2011 09:42 AM|MyronCope|LINK
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.
Jul 27, 2011 11:22 PM|You-Hu Fu|LINK
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.