Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Columns as Rows in a Table

Posted on 2016-09-23
14
Medium Priority
?
105 Views
Last Modified: 2016-09-26
Hello Experts Exchange
I have a SQL Server Reporting Services report that has a dataset with several columns, I want these columns going down as rows on the left hand side in a table, and my data from the columns going across by date.

My Columns are called;
TA_Date
TA_Notes_50
TA_Notes_20
TA_Notes_10

What are the steps required to do this?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
[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
  • 8
  • 6
14 Comments
 
LVL 13

Expert Comment

by:Arifhusen Ansari
ID: 41812195
It's seems that you want to unpivot the data.

Like convert column to row.

If this is the case you can use the concept of pivot and unpivot in sql server it self.

It would be great if you post some example data and the expected output.
0
 

Author Comment

by:SQLSearcher
ID: 41812214
Hello
I have attached a sample of data.

The data is not in SQL Server it's in Oracle.

Regards

SQLSearcher
Sample_Data.xls
0
 
LVL 13

Expert Comment

by:Arifhusen Ansari
ID: 41812219
What is the expected output?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:SQLSearcher
ID: 41812257
Hi
Please find sample data with wanted output.

Regards

SQLSearcher
Sample_Data.xls
0
 
LVL 13

Accepted Solution

by:
Arifhusen Ansari earned 2000 total points
ID: 41812265
Ok.

I have attached the rdl file with the same solution.

I am trying to explain you in  brief.

I have used the matrix in the report.

I column group i have used the TA_Date field from the data.
Refer the screenshot.

2016-09-23_16-31-04.png
And in the data part of the martix i have used the list control.
Delete the row group from the list and add three row in it.
This list will in the data part of matrix.

In those three rows in list select the filed from the data as per your req.

Refer the screen shot

2016-09-23_16-33-25.png

In the row part again add the list.

2016-09-23_16-35-13.png
and remove the group from the list and add name hard coded.

Refer the screenshot.

2016-09-23_16-35-34.png
i have attached the rdl. Please check.


Final output

Final-Output.pngcolumntorow.rdl
0
 

Author Comment

by:SQLSearcher
ID: 41812329
Hello Arif
Can you zip up the rdl file and attached so I can download it please?

Regards

SQLSearcher
0
 
LVL 13

Expert Comment

by:Arifhusen Ansari
ID: 41812368
0
 

Author Comment

by:SQLSearcher
ID: 41812395
Hello Arif
Can you in Visual studio open the rdl file and do this please?
solution > properties > TargetServerVersion set to SQL Server 2008 R2.

I'm getting an error when I try to  open the rdl file. Similar to this;
http://stackoverflow.com/questions/35922626/error-while-uploading-a-report

I'm using Visual studio 2013.

Regards

SQLSearcher
0
 
LVL 13

Expert Comment

by:Arifhusen Ansari
ID: 41812446
Even if i change this i will not have any impact.

I need to create the report in same version and lower version.
0
 

Author Comment

by:SQLSearcher
ID: 41812448
OK, I'm currently installing Visual Studio 2015 on my machine.
0
 

Author Comment

by:SQLSearcher
ID: 41812544
Hello Arif
I have been able to get it running but I can not work out what you have done.

I have the date in the Columns field and inserted a list in the data field, but I can not insert a new row into the list.

How do I do that?

Regards

SQLSearcher
0
 

Author Comment

by:SQLSearcher
ID: 41815957
Hello Arif
I have worked out how to create the matrix, is there a way to add a total column on the far right of the table?

Regards

SQLSearcher
0
 

Author Comment

by:SQLSearcher
ID: 41815970
Hello Arif
I worked out the Total to.

Thank you for your help, you have been great.

Regards

SQLSearcher
0
 
LVL 13

Expert Comment

by:Arifhusen Ansari
ID: 41815987
Thanks for your feedback.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
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…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 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