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.
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
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.
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
Thanks
Sreeni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |