1. balajimcasoft New Member

   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

   balajimcasoft, Feb 1, 2007

   #2
2. satya Moderator

   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.

   satya, Feb 3, 2007

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in