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
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??