Hi I am using report builder 2.0 and have a table that has 19 columns. Out of these columns 1 does not show the values of the query that I have created. In the query design window the values of teh mdx query show but not in the report. I have created the table aganand still the same problem even if the only column present if the one with no values. All the properties look the same but I am not sure why this is happening Any ideas

Hi aivoryuk, First of all, check whether the field got any value or not. If the value of the missing field is null, and if you used NON EMPTY{} expression in your dataset then it won't be showing that. Another thing you can check is (I faced this scenario), whether the same field is included multiple times inside your query. If it is the case, then remove the duplicate entries. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/

Hi aivoryuk, First of all, check whether the field got any value or not. If the value of the missing field is null, and if you used NON EMPTY{} expression in your dataset then it won't be showing that. Another thing you can check is (I faced this scenario), whether the same field is included multiple times inside your query. If it is the case, then remove the duplicate entries. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/

Hi aivoryuk, First of all, check whether the field got any value or not. If the value of the missing field is null, and if you used NON EMPTY{} expression in your dataset then it won't be showing that. Another thing you can check is (I faced this scenario), whether the same field is included multiple times inside your query. If it is the case, then remove the duplicate entries. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/ Hi Sorry not get back to you earlier. It was the 2nd of your solutions, I have duplicated the measure in the MDX query DOH! :).