Problem with report ( show only first row of my related contact)
I have a table called customers and another one called related_customers. In my layout, I have the possibility to add related contacts to customers table. So, these contacts are created in the related_customers table.
Now, I would like to show that in report :
customers:FirstName customers:LastName related_customers:FirstName related_customers:LastName
I could only see the first contact but sometimes, I don't have any related contacts and we could also have 1 to 4 co-part for 1 part.
I know that we could use portal to show and it works. But, I must defined the "number of rows" to show in report. As I previously said, some customers have no related_customers and somes customers could have until 4 related_customers.
Do you have any idea how to do that ?