Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS horizontal  data display with wrap matrix

Posted on 2014-10-06
2
Medium Priority
?
1,226 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Loops Section Overview
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses
Course of the Month15 days, 2 hours left to enroll

577 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