Announcements
Currently I have a list that is horizontal and I would like to leave it in the following layout:
How can I do this using report service?
In this case it doesn't work for me because I'm using fetch xml and not sql
Hi,
First of all you need to write correct SQL command with groups of rows numbers
select Mod3 = (row_number() over (PARTITION BY Mod2 ORDER BY Id)), Mod2, Id from ( select Mod2 = (row_number() over (ORDER BY Id)) % 2, Id from ( select 'Id' = '1' union all select 'Id' = '2' union all select 'Id' = '3' union all select 'Id' = '4' union all select 'Id' = '5' ) datatable ) tt order by id
Then create matrix table
Then remove rows and columns headers
Insert subreport with parameter of row id
Yes it is 2 columns, N rows
Hi,
Does this report have 2 columns, N rows or vice versa?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156