Report builder field with mutiple values separated by a colon

Question

I'm new to report builder and I'm trying to something like this:

Part A:

serialNum,serialNum,serialNum,serialNum,serialNum...

Part B

serialNum,serialNum,serialNum,serialNum,serialNum...

. . for all the parts in an invoice

Another choice would be in columns Part A

        serialNum  serialNum  serialNum  serialNum serialNum
        serialNum  serialNum  serialNum  serialNum serialNum

Does anybody how to achive this or something similar with Report Builder?

Answer 1

Create a tablix (white color) with the a row group on part values with two rows. On the first row you will display the part value

Create a tablix (blue color) with a column group on serial values. Delete the row group and hide the detail.

Now drag the tablix(blue color) with the column group on the 2nd row of the tablix (white color) with the row group.