January 16, 2012 at 11:08 am
I am doing a report in which the data come from both Header and detailed information. I need the detailed to print grouped by Customer invoice
Invoice 1
Item Qty Price Freight
9090 10 2.00
8989 4 5.00
78798 6 7.00
Total 20 14.00 8.00 ( this is based off a header amount)
Invoice 2
Item Qty Price Frieght
9090 10 2.00
8989 4 5.00
78798 6 7.00
Total 20 14.00 8.00 ( this is based off a header amount)
Customer
Total 40 28.00 16.00
I created a second table to pull the custom totals so I get one line for freight instead of adding 8 multiple times.
My problem is the second table prints at the END of the report not on the same page. I know I have done this before but I cannot seem to remember how to connect the 2 tables.
Any thoughts are appreciated.
Sorry if I did not explain this well enough too and you need more info.
January 17, 2012 at 8:06 am
If I understand your problem correctly, I approach this a bit differently. I wrote a blog about it here:
February 2, 2012 at 8:15 pm
Thanks. Your blog helped so much. It was great.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply