# Sorting Reports

**URL:** <https://www.dynamicsuser.net/t/sorting-reports/55581>\
**Category:** User Forum\
**Created:** [October 31, 2014, 9:54am UTC](https://www.dynamicsuser.net/t/sorting-reports/55581 "2014-10-31T09:54:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lama\_L](https://avatars.discourse-cdn.com/v4/letter/l/eb8c5e/32.png) [@Lama\_L](https://www.dynamicsuser.net/u/Lama_L)\
**Post date:** [October 31, 2014, 9:54am UTC](https://www.dynamicsuser.net/t/sorting-reports/55581/1 "2014-10-31T09:54:26Z")

</div>

Hi ,

I can’t seem to know how to sort the pay statements report according to ascending personnel number.

I tried to do so by clicking “Select” --\>“Sorting” tab before I run the report for a specific pay period of course, but I can’t find the personnel number field by which I can do the sorting .

Any help ??

---

<div class="post-metadata">

**Author:** ![saurabhpsingh](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@saurabhpsingh](https://www.dynamicsuser.net/u/saurabhpsingh)\
**Post date:** [November 3, 2014, 1:03pm UTC](https://www.dynamicsuser.net/t/sorting-reports/55581/2 "2014-11-03T13:03:01Z")

</div>

Hope I understood this right. You are trying to sort a report using a field whose table is not directly present in the report query. Open the report, go to the query, right click and select the relating table. E.g. worker table in this case.

 ![6445.Untitled.png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/3/32e656fe623bd8cc09adcb5ce6b91db23e8abfc2.png)

Then select your new table in the sorting criteria. This should do the job.

-Saurabh