Skip to main content

Power BI

New

Report Builder error points to S o r t E x p r e s s i o n property of Details group but error in in the U s e r S o r t property of one of the columns in the Tablix

Vote (2) Share
Gary THOMANN's profile image

Gary THOMANN on 12 Apr 2022 04:06:47

Incorrect error message from Report Builder

'The S o r t E x p r e s s i o n expression for the grouping 'Details' refers to the field 'field'. Report item expressions can only refer to fields within the current dataset scope ' etc

Comments (2)
Gary THOMANN's profile image Profile Picture

Gary THOMANN on 02 Nov 2022 05:03:24

RE: Report Builder error points to S o r t E x p r e s s i o n property of Details group but error in in the U s e r S o r t property of one of the columns in the Tablix

22 Limitations or Things Hard to Do in SSRS The Baker’s Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting Services 

Gary THOMANN's profile image Profile Picture

Gary THOMANN on 12 Apr 2022 04:10:58

RE: Report Builder error points to S o r t E x p r e s s i o n property of Details group but error in in the U s e r S o r t property of one of the columns in the Tablix

Turns out it is the angle bracket usage is the issue ... fix this.ie I had '{left angle bracket}field{right angle bracket}'