I already knew your answer was correct. It seems like it should be so easy. My boss is being a real a$$ about it.

So, I guess I want it to look like this:

Data1Result

SOME TEXT

Data2Result

To be clear, this is all in one field based on an expression.

Your answer is so funny to me! Exactly what I asked. Stupid user request. I'm viewing it in SSRS 2005. They want the report to "look...

Thanks for your help, Steve.

That line of code returns nothing,

but if I do this Descendants([ServiceCharge].[Sector Type].&Electric, [ServiceCharge].[Sector Type].&Gas) ON ROWS

I get Electric and not Gas.

Ann

The first line of code returns everything, which is what I am trying to avoid in my parameter dropdown list and the second line of code returns nothing. I...

Thanks Steve,

Unfortunately that did not work. When I ran your query against the cube it came back with no results.

Ann

No - I haven't found the answer. But, only because job requirements have taken me in another direction. Putting out fires. But, I will return to this...

I appreciate your help, but take a...

I searched the forums with one result, that didn't address what I need.