You can get the result you want without using merge fields.
- Create a layout based on your phone number portal.
- Place the fields from your related parent record in the header part of this layout, put the phone number fields in the body.
- Now perform a find to find all the phone number records for one contack--sort it if you want, and you've got the results you want.
- If you want to list multiple contacts on one report this way, modify your layout--changing the header into a sub summary part "when sorted by" contact ID. Make sure your sort your records by contact ID to group them correctly and to make the sub summary part visible.
Hi Phil Thanks For replying . I tried that method, i got the list of phone numbers, and its according to customer ID, one more question , How can i embed that in to this report http://hotfile.com/dl/73749595/56f4ff9/Untitled.pdf.html this is complete report http://hotfile.com/dl/73750003/7a6ca80/2.pdf.html and this is my new test layout
Had to jump through a few more hoops and wait a lot longer for that PDF than you do from most filesharing sites....
That does add a complication that I wish I'd known about from the start. That gives you two portals to two different related tables and makes my original suggestion less than optimal. I'd base the report layout on the second portal's table and keep the phone numbers in a portal. I don't see any advantage to using merge text.
It can be done using a calculation field in the Phone numbers table to combine all the fields in the portal row and a calculation field in the parent table that uses list to list the calculation field you've just defined in the portal table. I just don''t see where that gains you anything.