fpkeegan
asked on
SSRS horizontal data display with wrap matrix
The example data from a select
title Data 1 Data 2 Data 3
T1 D1-1 D2-1 D3-1
T2 D1-2 D2-2 D3-2
T3 D1-3 D2-3 D3-3
T4 D1-4 D2-4 D3-4
T5 D1-5 D2-5 D3-5
T6 D1-6 D2-6 D3-6
T7 D1-7 D2-7 D3-7
The report output in SSRS should have the data displayed horizontally , but it should wrap after 4 output columns. The value for the header (title ,data 1 ,data 2, data 3)can be hard coded. The number of rows from the select will be variable.
Title T1 T2 T3 T4
Data 1 D1-1 D1-2 D1-3 D1-4
Data 2 D2-1 D2-2 D2-3 D2-4
Date 3 D3-1 D3-2 D3-3 D3-4
Title T5 T6 T7
Data 1 D1-5 D1-6 D1-7
Data 2 D2-5 D2-6 D2-7
Date 3 D3-5 D3-6 D3-7
I believe that this is a matrix imbed into a matrix , but I do not know how to get the rows, columns and titles to line up. And what are the group-by functions.
I can do a simple matrix but it does not wrap correctly with the headers (title ,data 1 ,data 2, data 3)
title Data 1 Data 2 Data 3
T1 D1-1 D2-1 D3-1
T2 D1-2 D2-2 D3-2
T3 D1-3 D2-3 D3-3
T4 D1-4 D2-4 D3-4
T5 D1-5 D2-5 D3-5
T6 D1-6 D2-6 D3-6
T7 D1-7 D2-7 D3-7
The report output in SSRS should have the data displayed horizontally , but it should wrap after 4 output columns. The value for the header (title ,data 1 ,data 2, data 3)can be hard coded. The number of rows from the select will be variable.
Title T1 T2 T3 T4
Data 1 D1-1 D1-2 D1-3 D1-4
Data 2 D2-1 D2-2 D2-3 D2-4
Date 3 D3-1 D3-2 D3-3 D3-4
Title T5 T6 T7
Data 1 D1-5 D1-6 D1-7
Data 2 D2-5 D2-6 D2-7
Date 3 D3-5 D3-6 D3-7
I believe that this is a matrix imbed into a matrix , but I do not know how to get the rows, columns and titles to line up. And what are the group-by functions.
I can do a simple matrix but it does not wrap correctly with the headers (title ,data 1 ,data 2, data 3)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER