Create Dynamic Rows based on column data

Marcus Allen 20 Reputation points
2024-06-03T17:44:22.2133333+00:00

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.

Stackflow help image 1

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,591 Reputation points
    2024-06-04T01:56:21.0633333+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Olaf Helper 42,581 Reputation points
    2024-06-03T18:24:11.7+00:00

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

    0 comments No comments