Reporting Services Query designer toolbar disabled

Hi to all , i'm trying to modify an mdx generated by query designer in "Design" mode.
I would like to switch to query designer in "Query" mode but the query designer toolbar and its button "Change Type" appears to be disabled.
In this project i use a shared data source and the data source type is Analysis Services.
In another project I followed the first basic Tutorial on Reporting Service ("Sales Order" report) so data source it's SQL Server and query designer it is locked to Query Mode and i cannot change it to Design Mode.
Thanks for help.
Alberto De MarcoI'm not sure which buttons you are referring to. Could you attach a picture of what you are seeing?

-Albert

Reporting Services Query designer toolbar disabled

Hi to all , i'm trying to modify an mdx generated by query designer in "Design" mode.
I would like to switch to query designer in "Query" mode but the query designer toolbar and its button "Change Type" appears to be disabled.
In this project i use a shared data source and the data source type is Analysis Services.
In another project I followed the first basic Tutorial on Reporting Service ("Sales Order" report) so data source it's SQL Server and query designer it is locked to Query Mode and i cannot change it to Design Mode.
Thanks for help.
Alberto De MarcoI'm not sure which buttons you are referring to. Could you attach a picture of what you are seeing?

-Albert

Reporting Services OLAP Report through Report Manager

I am creating a report in Reporting Services that hits an Analysis services
cube using MDX. The report has parameters so some of the MDX queries are
placed into strings. When running the report on my local machine it works
correctly, but when I deploy the report and run it through Report Manager it
locks up and will not display. It also brings down the Web server for a few
minutes.
The parameter lists in the report are created with a static MDX statement
and they will display, but the report keeps turning and never renders to the
screen.
I have looked at the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
but I cannot find anything on why the report would work locally but not
through Report manager.
Any advice or directions would be greatly appreciated.I was able to solve this problem. The SQK server with my Cubes had Analysis
Services SP3. The box that I was developing the OLAP report was also running
AS SP3 but the Report Server did not have any service packs installed. This
was causing the OLAP report to lock up on the report server. Analysis
services was installed onto the report server after the report server and
visual studio. I believe that Analysis services over wrote the MSOLAP80.dll
to the 8.0.195 version.
After installing AS SP3 on the report server I was able to view OLAP Reports
through the Report Manager without locking up or bring down the web server.
"AndyT" wrote:
> I am creating a report in Reporting Services that hits an Analysis services
> cube using MDX. The report has parameters so some of the MDX queries are
> placed into strings. When running the report on my local machine it works
> correctly, but when I deploy the report and run it through Report Manager it
> locks up and will not display. It also brings down the Web server for a few
> minutes.
> The parameter lists in the report are created with a static MDX statement
> and they will display, but the report keeps turning and never renders to the
> screen.
> I have looked at the site
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> but I cannot find anything on why the report would work locally but not
> through Report manager.
> Any advice or directions would be greatly appreciated.
>