Skip to main content
Microsoft Idea

    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}'