SQL Server 2005 Reporting problem
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