Share
ReportCurrently 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?
Categories:
You’re offline. This is a read only version of the page.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
