SQLSearcher
asked on
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
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
ASKER
Hello
I have attached a sample of data.
The data is not in SQL Server it's in Oracle.
Regards
SQLSearcher
Sample_Data.xls
I have attached a sample of data.
The data is not in SQL Server it's in Oracle.
Regards
SQLSearcher
Sample_Data.xls
What is the expected output?
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Arif
Can you zip up the rdl file and attached so I can download it please?
Regards
SQLSearcher
Can you zip up the rdl file and attached so I can download it please?
Regards
SQLSearcher
DOne
columntorow.zip
columntorow.zip
ASKER
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
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
Even if i change this i will not have any impact.
I need to create the report in same version and lower version.
I need to create the report in same version and lower version.
ASKER
OK, I'm currently installing Visual Studio 2015 on my machine.
ASKER
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
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
ASKER
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
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
ASKER
Hello Arif
I worked out the Total to.
Thank you for your help, you have been great.
Regards
SQLSearcher
I worked out the Total to.
Thank you for your help, you have been great.
Regards
SQLSearcher
Thanks for your feedback.
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.