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
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
Thanks Gobinath, it worked. Aprreciate your help.