I've got a report with a table and the columns are grouped.
The setup would be something like this
Category 1 - Test Category 1 details 1
Category 1 details 2
Category 1 details 3
Category 2 - Test Category 2 details 1
Category 2 details 2
Category 2 details 3
Category 2 details 4
I've got my own numbering value that's being passed into the report which produces those details 1, 2 ,3, etc.... And then I go into my group column properties and set sorting to that field = Fields.OrderNum ASC. It seems to only sort the first row and then every other subsequent rows are not sorted so the numbers are all out of place. How would I go about fixing this issue?
Thanks