Hi Guys,
I am trying to create a dynamic report using RS 2005 with AS2005. My
report has fixed columns whose names and values are substitued at
runtime with data from queries.

I am actually facing the problem as described in this topic.
http://groups.google.co.uk/group/mic...98d0475958720c

There is alreay an answer in that topic, but what i want is a bit more
than that.
In my report data is not just populated from one dimension, it's
actually populated from more than one dimensions and levels in the same
query.

If this was in T-SQL, i would have simply given column alias for each
like "CustomerName" AS COL1, "CustomerPhone" AS COL2, etc.

Does anyone know how to achieve this in MDX. ie how to give aliases for
MDX columns for reporting services 2005?

Thanks
Raj Chidipudi