Repeat rows in SSRS

Finance and Operations/AX Developer Forum
1

Hi,

I have created a report and in the body inserted a table of 5 rows and 11 columns.

I wish to repeat the third row based on some logic in at X++.

Will matrix be of any use or I can achieve it using table in the body?

2

Can you explain your requirement in more details?

And what kind of datasource does the report use? A query or an RDP class? Because it may be easier to handle it there instead of inside the report.

3

Hi Martin,

I am using the RDP report.

Let us assume that I am inserting data in a temporary table Tab1.

Tab1.col1 = '1';

Tab1.col2 = 'THIS IS';

Tab1.col3 = 'TEST';

TAB1.insert();

Tab1.col1 = '2';

Tab1.col2 = 'THIS IS';

Tab1.col3 = 'TEST';

TAB1.insert();

I have inserted a table in the design body of an SSRS report.

now the expected output is:

1 THIS IS
TEST
2 THIS IS
TEST

the number of empty rows will vary depending of the logic

4

You can write an expression to hide the controls you don’t need in any particular case.