how to split data in two columns based on value in DB - SSRS

Question

Hello all,

I am totally new to this paginated report thing for Power BI, and I got request to create a paginated report with layout shown below:

position of column is determined by a value in the db shown in the example below:

Can someone tell me how to do this in Power BI Report builder or SSRS?

I am looking forward for your answers or pointers,

Thanks in advance

Answer 1

Hi @Vashko

Since the table style you want is alternating rows and columns, choosing a matrix is the best way.

But according to your original data, if you want to use the row groups of the matrix, you need to group and number them according to the "parent" to facilitate use. So when adding a dataset, we can use the following statement.

Then add the matrix, adding the "rank" field to the rows, the "parent" to the columns, the "name" to the data, and then one more column parent group "Grandparent".

Finally, if we don't want the "rank" to be displayed, we can choose to delete the row, just delete the row.

Preview:

If the answer is helpful, please click "Accept Answer" and upvote it. If you have any questions, please feel free to let me know.

Best regards,

Aniya