Imagine there are two tables. First contains personal information of account owners (name, document, address). The second has account information (how many shares of each kind there are on each account). There may be several account owners for the same account (say, person 1, person 2 and person 3 for one account). On this account we may have two kinds of shares.
What I try to do is to display this information as on the attached image. One part of the report contains personal information of all account owners (Name, address). Another part, which is mixed with the first one, contains the overall information for three owners: account id and share counts. The account id is the connector that links the two tables.
How can I achieve such layout?
Master and detail in the same row
Master and detail in the same row
- Attachments
-
- accts.png (21.68 KiB) Viewed 3034 times
Re: Master and detail in the same row
Here the sharecount table is the Master, and it may have several details. In 90-95% cases there would be just one person. If it was 100%, I would simply join the tables on the server, but since we have those 5-10%, we can't do this. Well, obviously we can, and then play with visibility of some cells, but this is far not the best practice.
Re: Master and detail in the same row
Hello.
You could set the Processing Duplicates property of the repeating text components to Merge.
You could read more on the User Manual.
Thank you.
You could set the Processing Duplicates property of the repeating text components to Merge.
You could read more on the User Manual.
Thank you.
Re: Master and detail in the same row
Hello! Thanks for your reply.
But how will it behave if the duplicate is intended.
Say there are two different accounts, for simplicity they are 7V and 8V, both have 1000 shares. This is highly possible.
In this case the sharecounts get merged, won't they? Can such merge be directed by a predefined column? In this case by accountId?
When we get to the image, attached to the 1st message, all owner of account 7V should be merged. But not the owners of other accounts.
But how will it behave if the duplicate is intended.
Say there are two different accounts, for simplicity they are 7V and 8V, both have 1000 shares. This is highly possible.
In this case the sharecounts get merged, won't they? Can such merge be directed by a predefined column? In this case by accountId?
When we get to the image, attached to the 1st message, all owner of account 7V should be merged. But not the owners of other accounts.
Re: Master and detail in the same row
Hello.
In this case you could use the Merge based on Tag value of the Processing Duplicates property.
You could set the Account in the Tag property and the merging will be for the texts with the same Tag property.
Thank you.
In this case you could use the Merge based on Tag value of the Processing Duplicates property.
You could set the Account in the Tag property and the merging will be for the texts with the same Tag property.
Thank you.
Re: Master and detail in the same row
Thanks! Displaying just fine now!
Re: Master and detail in the same row
Hello
We are always glad to help you!
Let us know if you need any additional help.
Thank you.
We are always glad to help you!
Let us know if you need any additional help.
Thank you.