May 6, 2011 at 10:35 am
Trying to run a report that retrieves data from cube. A particular column has no values in it, so when I execute the query in query designer it not showing up that column and when trying to preview the report it displays the following error:
Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Any help on this would be greatly appreciated!!
May 6, 2011 at 2:35 pm
sreeya (5/6/2011)
Trying to run a report that retrieves data from cube. A particular column has no values in it, so when I execute the query in query designer it not showing up that column and when trying to preview the report it displays the following error:Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Any help on this would be greatly appreciated!!
It sounds like you have 2 problems.
-The first is that no data shows up in the query designer. Fix this problem first.
-The second problem is your report has an expression that has a reference that is outside the the scope where the text box is, a group for example.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply