MDX syntax error only on VS 2005

Hi, look im having this error frecuently on Visual Studio 2005, while executing a MDX query...

SELECT NON EMPTY { [Measures].[Budget Lead Count] } ON COLUMNS
FROM [LTL_Budget_Forecast] CELL PROPERTIES VALUE

but when I execute the same query on SQL Management Studio 2005, everything goes fine... and the query is executed successfully

Do you know what could be the problem here?

thx...

Regards,

-EWhat is the exact error you are getting? And where are you executing the query from? Is it in reporting services? The reporting services provider does some extra work and I would guess that the "non empty" clause on the columns would update reporting services as it requires a fixed set of columns.|||Thanks Darren,
the exact error displays as follows:

SQL Execution Error

Executed SQL Statement: SELECT NON EMPTY { [Measures].[Budget Lead Count] } ON COLUMNS
FROM [LTL_Budget_Forecast] CELL PROPERTIES VALUE
Error Source: .Net SqlClient Data Provider
Error Message: Incorrect syntax near '{'

Im executing this query on MS Visual Studio 2005, and my project is a Report Server Project|||

> Error Source: .Net SqlClient Data Provider

There's your problem. You should be using either the Analysis Services Provider or the OLEDB provider with the MSOLAP 9.0 OLE DB driver. The Analysis Services Provider gives you a friendlier MDX designer experience, so I would probably try that one first.

If you have both SQL and MDX based reports you will need to set up a second data source. If the report project only needs to run MDX queries, the you will need to change the details of the current data source.

|||Thanks a lot Darren, I solved that problem setting up a second data source...

Regards,

-E