Solved

SSRS horizontal  data display with wrap matrix

Posted on 2014-10-06
2
690 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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

929 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now