Not clear from your post what you want. The post title indicates you want to add columns after those displaying data for your grouping. For a Matrix, that makes sense and it would be done using Insert Column > Outside Group - Right. For a table that groups by rows only, all columns are part of the grouping. When adding a column the choice is only Left or Right, not Inside or Outside Group.
Your example seems to indicate that you are displaying all phone numbers for a given id, on separate rows and you only wish to display the id and name on the first row. If that is the case, you can do this easily if you are willing to display id, Name, Number (in that order).
Assuming Name is the same for the same id, simply create a table and assign it to your dataset. Add a parent group for id. This will create a new column for the group and will display id in the cell. Right-click the group column selector (grey box above the column) and choose Insert Column > Inside Group - Right. Add the name field to this new column. Now set the first data cell to the number field and delete the extra columns.
In my test this displayed:
| ID | Name | Number |
| 2 | George | 555-1212 |
| 654-0002 | ||
| 707-2111 |
"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.
No comments:
Post a Comment