Create Dynamic Rows based on column data

Question

New SSRS and need to find a way to add rows to a matrix based on a number of a column and input specific item based on the qty. The first table is dynamic based on the backend dataset values. For example, the first line in the top table has "3" fine and "5" flake". I need to find a way to dynamically add rows in the second table going down in the second column with the 3 rows that state fine and 5 rows stating flake. Currently I have staff circling the type by the number of qty in the first table.

Answer 1

Hi @Marcus Allen,

Do you mean if the number change to "2" fine and "8" flake", the second table should change with the 2 rows that state fine and 8rows stating flake dynamically?

If yes, SSRS could not do that. Rows are static when you design the report.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

SSRS shows only a result, you can not "add" not existsing rows, that must be done in the data source.