Solved

SSRS horizontal  data display with wrap matrix

Posted on 2014-10-06
2
909 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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 …
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

729 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