Sql reporting services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql reporting services

Hi iam having table in that table field name Xml units Values are
Units k="0",h="0",g="0",j="0"
Units h="0",k="0",j="0",g="0" Note :this are in row wise
I want output should be this format k h g j
0 0 0 0
0 0 0 0 In Sql reporting servies 2005 Thanks
k.balaji
Using BIDS you can setup a query to format this as a MATRIX based report. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |