SSRS Not sorting correctly

SQL Server 2012

In row groups, I changed first columns sorting to what I want. Go to Row group> Change sorting as shown in figures. Also, I have changed the tablix sorting.

I had the same issue, it would only sort on the Group which was the name not the sort order that I wanted. Changing the Tablix's sort order had no affect. I was able to address it by going to the Group properties and selecting Sorting. In there I changed the "sort by" property from the datasets "name" field to the datasets "sortorder" field and that fixed it. The Sort Order at the Tablix level apparently is overridden by the groupings sort order. Jay

Wow found it and as usual it is a bug in SSRS, I remember these sorts of things being bugs in SSRS 2005 and SSRS 2008. So even if you change the SortOrder in the designer, in my case I changed it to SortOrder. That didnt work...so what I did was right clicked on the actual report and did a "View Code". And I looked for SortExpression and it did not have the value SortOrder, its almost like in some cases when you update the report from the designer the code xml portion does not see those updates.

Anyhow I changed it such that the XML read this:

 <SortExpressions>
                            <SortExpression>
                              <Value>=Fields!SortOrder.Value</Value>
                            </SortExpression>
                          </SortExpressions>

Saved my report and ran it again and voila, all is well now. Lesson Learned to use prior experience with the "View Code" option to fix issues like this.

Here was the whole thing:

<TablixMembers>
                    <TablixMember>
                      <Group Name="Title">
                        <GroupExpressions>
                          <GroupExpression>=Fields!Title.Value</GroupExpression>
                        </GroupExpressions>
                      </Group>
                      <SortExpressions>
                        <SortExpression>
                          <Value>=Fields!SortOrder.Value</Value>
                        </SortExpression>
                      </SortExpressions>
                      <TablixMembers>
                        <TablixMember>
                          <Group Name="Details2" />
                          <TablixMembers>
                            <TablixMember />
                            <TablixMember />
                            <TablixMember />
                          </TablixMembers>
                        </TablixMember>
                      </TablixMembers>
                    </TablixMember>
                  </TablixMembers>

Whatever I did in the designer would not update the sortexpression value portion, this portion:

<SortExpressions>
                        <SortExpression>
                          <Value>=Fields!SortOrder.Value</Value>
                        </SortExpression>
                      </SortExpressions>

I tried through the designer but it never updated the XML, and running the report produced the wrong result. Its only until I manually changed the SortExpression to read Fields!SortOrder.Value did my report sort correctly.

Here's the screenshot as mentioned in the comments:

Better photo:

Even if I do it at the title level same issue: