Being new to Reporting Services, I believe there has to be a way to get total from header table to be added to subtotal just once, after header is joined to detail table.

ex header- ordtot,tax,ship,disc,ordernum
   detail - itemamt, prod,ordernum,itemseq
when joined
ordernumber,itemseq,ordtot,tax,ship,disc,itemamt,p rod

What I want is
 ordernumber seq itemamt,ordtot,tax,ship,prod
    12345 1 10.00 50.00 5.00 xyz
    12345 2 40.00 50.00 5.00 abc
     subtotal 50.00 50.00 5.00
but i get
                       50.00 100.00 10.00
Can anyone help??

Rich Hudec