detail data before master data

aaront

i have an invoice table and an invoice_items table, if i place the invoice table on a masterdata band and the invoice_items table on a detaildata band i get...

invoice number date total balance
item price
item price
item price
item price

invoice number date total balance
item price
item price

and so on, which works great, but i would like to print the invoice record after the invoice_items eg...

item price
item price
invoice number date total balance

if i put the invoice_items table on a masterdata band and the invoice table on a detaildata band i get...

item price
invoice number date total balance
item price
invoice number date total balance
item price
invoice number date total balance
item price
invoice number date total balance
item price
invoice number date total balance
item price

any ideas how to get it to only print 1 invoice record after the group of invoice_item records, thanx

boakoms

strange. it should be working as you wanted, dont know why it doesnt.

anyways, try this workaround :

master data band 1
detail data band 1
master data band 2

make sure that mater data band 1 is empty and make its height 0 from properties.