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?
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?
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.
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
You can write an expression to hide the controls you don’t need in any particular case.