View Single Post
 
Old October 5th, 2005, 09:32 AM
saikrishna_80 saikrishna_80 is offline
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server 2005 Reporting problem

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