We are in the process of converting CRs to Universes. For the CR reports, the parameter Fields have ALL and None values. Which not avilable in the LOV
I want to include ALL and None in my Object LOV. Please help me out in changing the SQL for the LOV in the Select distinct. Back end is SQL Server 2008.
The FAQ describes how to add ALL into an LOV. If you need also NONE to be added into the LOV then just do the same what FAQ talks about but for NONE now.
By the way, what does a report should do with a condition when NONE is selected?
I tried using the code
SELECT DISTINCT
CLARITY.dbo.PAT_ENC.CONTACT_DATE
FROM
CLARITY.dbo.PAT_ENC
UNION
SELECT ‘ALL’
UNION
SELECT ‘None’
But I when run and test the Lov object, I am only seeing the ALL and None Values.
In my scenario, I need like when I select 'ALL ’ >>>> should include all the list of values and for ‘None’ >>>> should not include any list of values.