I had a big problem showing data in one column in my report. It showed fine in BIDS but it didn´t show in my external reporting tool, similar to report manager..
I had to do like this:
I had to change the fields from where the dataset get it´s data. I changed my name to only “dimension path” + “.[MEMBER_UNIQIE_NAME]. Then i added a new query field with field source ending with “.[MEMBER_CAPTION], see picture. Then i used the “member_caption field to show in column.
Now it works both in BIDS and in external environment.