Page 1 of 1
Detail field in master data band
Posted: Fri Jun 17, 2011 7:05 am
by jmiller
I have a data band that shows the master data. Inside the band I have a sub-report that shows some detail records for that master record. In the master band itself, I want to display a field contained in the first record of the detail data: What is the best to do this?
Customer: John Doe
Last Invoice: May 01, 2011
Invoice History
May 01, 2011 1,000.00
Apr 01, 2011 950.00
Mar 01, 2011 950.00
---------------------------------- (next page)
Customer: Bill Smith
Last Invoice: May 17, 2011
Invoice History
May 17, 2011 3,000.00
Apr 17, 2011 2,500.00
Detail field in master data band
Posted: Fri Jun 17, 2011 7:27 pm
by Ivan
Hello,
Please check the report sample in attachment.
Thank you,
Detail field in master data band
Posted: Sat Jun 18, 2011 11:27 am
by mirzaei2003
Hi
i wanna know what is the best way for doing this but i can't understand your report sample can you please explain it?
Detail field in master data band
Posted: Mon Jun 20, 2011 2:02 am
by Alex K.
Hello,
In this case, columns from the Detail band are placed in the Master band, and because before the formation of the Detail band, the position is on the first entry, then on the Master band the first row from the Detail will be output.
Thank you.
Detail field in master data band
Posted: Mon Jun 20, 2011 9:36 am
by jmiller
This makes sense. Is there a way to do it if I needed the last record? This is same sample data, but the invoice history is reported in reverse order.
Customer: John Doe
Last Invoice: May 01, 2011
Invoice History
Mar 01, 2011 950.00
Apr 01, 2011 950.00
May 01, 2011 1,000.00
---------------------------------- (next page)
Customer: Bill Smith
Last Invoice: May 17, 2011
Invoice History
Apr 17, 2011 2,500.00
May 17, 2011 3,000.00
Detail field in master data band
Posted: Wed Jun 22, 2011 7:20 am
by Alex K.
Hello,
Please see the sample report in attachment.
Thank you.
Detail field in master data band
Posted: Mon Jun 27, 2011 10:15 am
by jmiller
I will look at the sample. Thanks for your help.
Detail field in master data band
Posted: Mon Jun 27, 2011 12:34 pm
by Andrew
Hello,
Ok! Let us know about the result.
Thank you.