Report Sort: Blank/Null at Bottom

1 posts, 0 answers
  1. Phil
    Phil avatar
    44 posts
    Member since:
    Mar 2015

    Posted 11 Jul Link to this post

    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?

    Thanks,

    Phil

Back to Top