In the report designer under group properties Make a group using the name of the field with the Order# then put the field obj for the order number in that header.
Then put the field obj for the Material# in the Detail header.
It should look like this:
Order#1
Material#1
Material#2
Material#3
Order#2
Material#4
Material#5
etc.