I've been searching for a weeks for my problem on the internet, but I haven't found it yet, here is my problem, I wish anyone here can help me to solve this.
Imagine I have the following data:
Customer
--------
cid : 1 | name: John ;
cid : 2 | name: Smith ;
PhoneNumber
-----
cid : 1 | number: 1234 ;
cid : 1 | number: 5678 ;
cid : 1 | number: 4321 ;
cid : 2 | number: 6745 ;
cid : 2 | number: 3124 ;
I want to make a report with subreport inside it with the following requirements:
- Customer ID -> 'cid' will use as report parameter
- report only show one customer together with his/her phone number
- One Page must only show one customer with one phone number
for example I took from customer details above with 'cid' = 1, it will generate 3 page because Customer with name "John" have 3 PhoneNumber.
Page 1:
Customer Name: John - Phone Number: 1234
Page 2:
Customer Name: John - Phone Number: 5678
Page 3:
Customer Name: John - Phone Number: 4321
My questions are:
- How I setup the Main Report to generate page according how many the subreport details?
- Which property I need to set on main report or subreport to fulfill my requirement?