[SQL 2005 Express] Question on Business Intelligence Development Studio (VS2005)

I am trying to create a report using BI Development Studio.

In Pivot Table, I can change the presentation of the data area to align with row or column, just like this:
http://img164.imageshack.us/img164/2055/untitledsi4.png

However, I can't seem to do that in BI Development Studio while designing the report. Does any of you know how to change the presentation of the data area of a report?

This is how it looks like now, the data area is sticking to the COLUMN, but I need them to stick with ROW so that I can handle more columns...
http://img103.imageshack.us/img103/4066/untitlednc8.pngmanage to resolve it by inserting just 1 details, then insert "Add ROW" at the details. This thing doesn't come with the Wizard. :D

[HELP] How can I start an Analysis Services service

Hi all,

at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.

I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.

How can I create an instance of Analysis Services.

Does anyone could help me please?

Thanks a lot.

Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.

Adrian Dumitrascu