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?
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148