SSRS Columns as Rows in a Table

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
SQLSearcherAsked:
Who is Participating?
 
Arifhusen AnsariConnect With a Mentor Business Intelligence Developer and AnalystCommented:
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
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
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
 
SQLSearcherAuthor Commented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
What is the expected output?
0
 
SQLSearcherAuthor Commented:
Hi
Please find sample data with wanted output.

Regards

SQLSearcher
Sample_Data.xls
0
 
SQLSearcherAuthor Commented:
Hello Arif
Can you zip up the rdl file and attached so I can download it please?

Regards

SQLSearcher
0
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
0
 
SQLSearcherAuthor Commented:
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
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Even if i change this i will not have any impact.

I need to create the report in same version and lower version.
0
 
SQLSearcherAuthor Commented:
OK, I'm currently installing Visual Studio 2015 on my machine.
0
 
SQLSearcherAuthor Commented:
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
 
SQLSearcherAuthor Commented:
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
 
SQLSearcherAuthor Commented:
Hello Arif
I worked out the Total to.

Thank you for your help, you have been great.

Regards

SQLSearcher
0
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Thanks for your feedback.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.