sql server reporting services: Hi,

I am trying to display the results of for example:
DRILLTHROUGH SELECT FROM [Request] WHERE [Day].[Day_Id].[5501]
inside a table of a report. I tried to follow
http://www.databasejournal.com/features/mssql/article.php/10894_3557476_10
but I didn't succeed:

I created a new dataset and entered the above statement into the Design mode
of the query builder. When I execute the statement, an error shows up:
"Query preparation failed. Additional information: Failed to parse the
query to detect if it is MDX or DMX. (MDXQueryGenerator)."
(In the Management Studio the query doesn't fail and shows the expected
results.)

What am I doing wrong?

Use OLEDB instead of "Microsoft Analysis Services" as Datasource-Typ and it
works!

"Ralph Watermann" <We.Want@NoSpam.de> schrieb im Newsbeitrag
news:eRMfBtQ8FHA.1276@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]