You’re offline. This is a read only version of the page.
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
Share
Report
All responses (
Answers (
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
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
