Hi.I developed SSAS2008 project, but we must deploy SSRS 2005.When i create Data sources and report, it isn't problem.Although i createonly one parameter, my report doesn't work if i choose multi values.(when i choose one value it is ok)i tried many methods but i couldn't success. may be this problem is caused by publishing old server. (publish : SSRS 2005 & develop : SSAS2008)Error Message : The query contains the ******* parameter, which is not declaredhow can i solve this problem?www.koraykocabas.com

You cannot build 2008 reports and deploy them to a 2005 server. The RDL schema is changed and the 2005 server doesn't recognize 2008 reports. -SeanProgram Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs

hmmm sorry.you can not understand my problem.I can not build 2008 reports.Ideveloped OLAP Project using SQL Server Analysis Services 2008, but i must publish my report which ,include my OLAP Project, on SQL Server Reporting Services 2005www.koraykocabas.com

In order to build SSRS 2005 reports, you will need to use Visual Studio 2005 w/ BI Development Studio or Report Builder 1.0. If you have Visual Studio 2008 installed, you will have to install BI Development Studio 2005 side by side or Visual Studio 2005 side by side.You should be able to connect to an SSAS 2008 cube in a SSRS 2005 report. Can you explain each step you are doing along the way and we can see if there's another issue here.-SeanProgram Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs

Sean, We are attempting to do exactly the same thing as this person. let me explain the issue in more detail. We have upgraded our data warehouse environment (SSIS, SQL-Server DB, and SSAS) to sql-server 2008R2. Unfortunately, we were not able to time the migration of our reporting server environment to this release to occur at the same time since we are planning to go to the SP 2010/RS 2008R2 integrated environment in the near future. So, we are running mixed mode with our reports still running under SSRS 2005. Everything works fine in this arrangement, except reports that run against our SSAS 2008R2 databases. Specifically, reports do not work if one attempts to choose more than 1 value from a parameter field (even though it's defined as a multi-value parameter). When doing so, the following error is returned: "Query execution failed for data set 'xxxx'. Parser: The query contains the xxx parameter, which is not declared." I have compared the MDX that is generated in the query builder (yes, we are using VS 2003 to develope these reports) and it is identical to the MDX that is generated for the same report using VS 2008. I have attempted to modify the MDX that is generated to no avail. The report works absolutely fine when developed in VS 2008 and deployed to our Sharepoint 2010 reporting site (which is not live in production yet). Is this a known issue? Is there a known work-around?

Sean, To add a bit more to this. I have confirmed that I can upload the exact report that does not work correctly (when selecting more than 1 parameter value from the list) and successfully run the report without the error mentioned in my earlier post from the test Sharepoint 2010/RS 2008R2 site. Robert Goodman