Detail field in master data band

[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

[Ivan]

Hello,

Please check the report sample in attachment.

Thank you,

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

[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.

[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

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.

[jmiller]

I will look at the sample. Thanks for your help.

[Andrew]

Hello,

Ok! Let us know about the result.

Thank you.