Solved

SSRS horizontal  data display with wrap matrix

Posted on 2014-10-06
2
746 Views
Last Modified: 2014-10-07
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)
0
Comment
Question by:fpkeegan
  • 2
2 Comments
 

Accepted Solution

by:
fpkeegan earned 0 total points
ID: 40365996
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
 

Author Closing Comment

by:fpkeegan
ID: 40366022
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question