Hi,

i have some problems with an element list from a dimension in Visual Studio .NET.
We work with OLAP (Microsoft Analysis Server an Microsoft Reporting Services SP1). We would like generate an list of members from an dimension for an simple filter in our report.
When i run the following MDX in der Microsoft MDX Sample Application we receive the result that we want. But when i run this MDX in the Visual Studion .NET Report Designer we receive all Members of the Dimension but for the
Member "All Products" we receive an empty field.

MDX Command:

WITH MEMBER Measures.NullColumn AS 'Null'
SELECT
{ Measures.NullColumn } ON COLUMNS,
{ [Products].AllMembers } on rows
FROM "Sales Cube"


Result in MDX Sample Application: (Thats correct)

"ALL Products"
"Product A"
"Product B"
"Product C"
"Product D"
a.s.o.

Result in Visual Studio .NET 2003:

" "
"Product A"
"Product B"
"Product C"
"Product D"
a.s.o.

Maybee anyone have a solution.

Thanks in advance...
Stephan

I would just do the following:

WITH MEMBER Measures.NameColumn AS '[Product].currentmember.name'
SELECT
{ Measures.NameColumn } ON COLUMNS,
{ [Product].AllMembers } on rows
FROM Sales