The Query Builder does take this.

But the issue is, it wont show me the Questions codes and Question Code Suffix on Columns.

Instead it treats them as measures and gives...

I even tried this way. To make the measure as a calculated member. So that I can trick the query designer to take it. Because the query designer will take...

WITH MEMBER Test AS

([Questionnaire].[Question Code]*

[Questionnaire].[Question Code Suffix])

SELECT {Test,[Measures].[Survey Count]} ON 0,

([Customer].[First Name].[First Name],

[Customer].[Last Name].[Last Name]) ON 1

FROM [Pet Co]

I tried doing this, if this is what you have in...

Aight! Thanks for your time.

It wont make a difference. It will still club all the fields on columns together. The only change is it will give an extra row for the ALL field.

Yes, have to use it in the report. SSRS wont take it. It crashes with this big code.

I appreciate your time though.

Either manipulate the code for the query...

This takes 18 secs to give me the results. (I have tried this before)

Think about when I join all the fields on rows. And moreover the above code will...

Okay. I used the questionnaire fields on rows with customer.(below), No luck, it throws system out of memory exception. There is too many fields for the server to cross join....

They do.

Can you please explain a little more?

Yes it does, I dont want to put it on rows either. It throws system out of memory exception. Because it has to cross join so many fields.

Thanks for the reply. I started off with a little. I need a solution for this though before I could jump into the link you have given.