
For your reporting needs, you may want to display values from a Lookup Table exactly in the order they are saved in PWA. Within PWA, this setting is controlled using “Display order for lookup table” option on Edit Lookup Table Page. However, this sort order is not available in Reporting Database. Following query