Letter Report

[shri]

Hi there,

I am trying to build report with customer name, address common message and number of cards they own.
for example,

Customer1
Address1

"Common message"

Card1

I want to print only one record per page. Some customers may have more than one card for examples

Customer2
Address2

"Common Message"

Card1
Card2

I tried with master detail relations, first page comes ok, but from second page onwards i get only Customer details and common message , no card details.

I don't know where i am doing wrong. Please shed some light on this.

Thanks

[Gopinath]

I faced the same scenario for one of our report. I used the following steps to achieve it. Let me know it solves your problem

Place a repeater and a table inside the repeater with 4 rows
drag and drop customer in row1, Address in row 2, a text item with 'Common Message' in row 3
place a list in row 4(Query 2)
create a master-detail relationship for Query1 and Query 2
Use Page Set for Page breaks

[shri]

Thanks Gobinath, it worked. Aprreciate your help.