Hi Friends,
         I am new to SQL Server Reporting services and i Have to create A crosstab report like this
       I want a Crosstab report like the below

                    Day1 Day2 Day3 Day4
       ____________________________________
        Sales 30 40 50 60
       ____________________________________

       Consumption 12 14 16 20
       ____________________________________

       OrderQty 16 17 21 22


But in SQL Server U can have only one column value or multiple column values besides each other in the Row header but not one below other as shown above.

Please treat this as urgent.

Thanks and regards
Sai Krishna

Read this http://www.aspfaq.com/show.asp?id=2462

http://sqlservercode.blogspot.com/