SQL Server Performance

Sql reporting services

Discussion in 'SQL Server 2005 Reporting Services' started by balajimcasoft, Feb 1, 2007.

  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
  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.

Share This Page