1

I would need to do a report looking like this : enter image description here

For any given "person" there is a single firstname, last name and age, but I can have as many surnames as the user sees fit. Each surname has a corresponding "apparition surname order". The column order is really important, but if that helps I could try to reorganise them.

I saw this post but it doesn't seem to be quite the result I'm looking for. Additionally each person has a unique id, but I don't want it to be displayed.

I've tried to use tablix inside a tablix and a matrix but I'm kinda lost to be honest. I would like to know if that is at least possible to achieve ?

Amon
  • 296
  • 1
  • 14
  • 1
    Check this answer https://stackoverflow.com/questions/66902255/unwanted-space-appearing-under-nested-table-in-ssrs-report/66950780#66950780 – niktrs Feb 09 '22 at 11:45
  • 1
    If you can move the Age by the Lastname, it's relatively easy with one level of grouping by ID with the name and then detail group for the Surname. – Hannover Fist Feb 09 '22 at 20:06

0 Answers0