Announcements
No record found.
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?
Hi,
Does this report have 2 columns, N rows or vice versa?
Yes it is 2 columns, N rows
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
In this case it doesn't work for me because I'm using fetch xml and not sql
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 166 Super User 2026 Season 1
Jimmy Passeti 51 Most Valuable Professional
NeerajPawar 51