Skip to Content

Hi All

I am explaining how to sort the LOV’s display in the prompts screen.

While running the report Cust ID LOV’s are not display in sort order, As a results user feel difficulty to select the values./wp-content/uploads/2014/06/1_472788.png

To apply  sort on Cust ID LOV’s -> double click the business layer under local project -> Select the parameters and lists of values tab -> Select the List of values based on custom SQL -> Specify the Name (Cust ID LOV)


Click on the Cust ID LOV and then click on the Edit SQL tab -> Specify the SQL in the editor -> Validate the expression and press OK


Sample Code





Click on the Preview tab and check the results. Lov’s are displaying in sort order or not.


Once the LOV’s are display sort order -> Select the Business layer and click on the field: Cust ID –> Click on the advanced -> Select a list of values button, will get pop-up showing all the Custom SQL list of values-> select the Cust ID LOV and press OK.


Save the Business layer and export the universe to repository and then refresh the report and check the LOV’s.

Hope this helpful



To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply