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)

/wp-content/uploads/2014/06/2_472789.png

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

/wp-content/uploads/2014/06/3_472946.png

Sample Code

SELECT DISTINCT FIELD

FROM

TABLE

ORDER BY 1

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

/wp-content/uploads/2014/06/4_472955.png

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.

/wp-content/uploads/2014/06/6_472954.png

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


Hope this helpful


Thanks

Sreeni


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