July 21, 2014 at 12:50 pm
I have created this report twice but don't seem to figure out the problem.
I keep getting this error
The SortExpression expression for grouping 'Name ' refers to field INOpen, report Item expressions can only refer to fields withing the current dataset scope or if inside an aggregate, the specified dasatset scope.
I checked and I haven't used any sort expressions on this group.
However m I still went ahead and removed the group and now it gives the error " SortExpression expression for tablix refers to field INOPen. report Item expressions can only refer to fields withing the current dataset scope or if inside an aggregate, the specified dasatset scope"
Cant figure out where am I sorting , apart from the query that too only on name and not INopen.
July 21, 2014 at 4:16 pm
In the properties for the tablix, is there anything on the Sorting tab?
July 23, 2014 at 6:00 am
Hi,
The error message is saying that you have a field in a sort option in your report but this field does not exist in your data set.
This normally occurs when you amend the data set on an existing report and a field is removed or the name for the field is changed. Reporting Services is case sensitive so if the field name has changed case then this can cause the error.
From the message it looks as if you have a sort option on the table object, right click on the table and select tablix properties and then click on the sorting tab and either remove or change the sort value.
HTH
April 28, 2017 at 4:57 am
Hi,
You can go to view code in the solution explorer and find for the value "INOpen".Delete it from there and save. In the design tab, go to the group properties, then go to the sort tab and delete the value "INOpen" (if it appears). Now, preview your report.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply