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)
fpkeeganAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fpkeeganAuthor Commented:
The oracle database setup for the test data.

CREATE TABLE TEST_TABLE
(
  title    VARCHAR2(10 CHAR),
  data_1   VARCHAR2(10 CHAR),
  data_2   VARCHAR2(10 CHAR),
  data_3   VARCHAR2(10 CHAR)
);



insert into test_table (title,data_1,data_2,data_3)values ('T1','D1-1','D2-1','D3-1');
insert into test_table (title,data_1,data_2,data_3)values ('T2','D1-2','D2-2','D3-2');
insert into test_table (title,data_1,data_2,data_3)values ('T3','D1-3','D2-3','D3-3');
insert into test_table (title,data_1,data_2,data_3)values ('T4','D1-4','D2-4','D3-4');
insert into test_table (title,data_1,data_2,data_3)values ('T5','D1-5','D2-5','D3-5');
insert into test_table (title,data_1,data_2,data_3)values ('T6','D1-6','D2-6','D3-6');
insert into test_table (title,data_1,data_2,data_3)values ('T7','D1-7','D2-7','D3-7');
commit;


-- the dataset query for DataSet1
select * from test_table;


Using
Microsoft Visual Studio 10.0.40219.1 sp1
Microsoft SQL Server Reporting Services Designers Version 11.0.5058.0

1) start with a blank report.
Blank
2) add matix item to the report, set the data set on the tablix to DataSet 1
add matrixS3.JPG
3) add three addition rows to the tablix
S4.JPG
4) right click in the row heading area and select split cells
s5.JPG
5) add the row headers and the data to the matrix
S6.JPG
6) set the column group by to the "Title"
delete title rowAdd group by title
7) delete the outer title row, delete "Row only"
 S9.JPG sample matrix8) run a Preview
Preview 1
9) The trick
      a) move the matrix to the side
      b) add a list item.
     c) make sure that the list item has the dataset set to "DataSet1"

S11a.JPGlist and matrix
10) drag the matrix into the list item
S13.JPG
11) On the list item add the group by expression =Ceiling(RowNumber(Nothing)/4)  this will put 4 items then wrap
list group bylist group
12) Preview
preview 2Matrix-wrap.rdl
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fpkeeganAuthor Commented:
I created the problem and later found and figured out  the answer. The RDL file for the example is enclosed. Screen shots of each step. should make it easier of the next person with the problem
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.