I am having a problem with sorting within a group on my report. The group needs to sort alphabetically which works, but I want the blank/null values to sort to the bottom of the list. When I sort alphabetically ascending, the blanks/nulls always go to the top of the sort.
In the datasource, I can make the blank values send in as blank or as null, whichever is needed for this functionality.
I have tried sorting by null, then by name but it still puts the blank/null values at top.
Is there anyway to sort alphabetically ascending with these blank/nulls at the bottom of the list?