I am trying to add an all object to my LOVs. I have been through many of the posts and I did find one that referred to SQL Server, but I cannot make it work.
I have added the following to my LOV
UNION
SELECT ‘ALL’
When I select my LOV I can see ALL being displayed, but when using ALL in a condition it returns nothing when it should return everyting. Can someone please tell me what I am doing wrong.
Just displaying ‘ALL’ in the LOV object is not enough
Use the following to create a predefined prompt condition :
@Select(Sales\Currency) IN @Prompt('Enter currency code or ALL','A',Sales\Currency',MULTI,FREE)
or 'ALL' in @Prompt('Enter currency code or ALL','A',Sales\Currency',MULTI,FREE)
Drag this condition in the report and then selecting ‘ALL’ will bring all values.
Try selecting from any of your tables. It should be fine as you are selecting a literal value from it. Pick a small one of course or create your own dummy table like dual. i haven’t tried it on db2 though.
I am confused now.I am just wondering why should we create a dummy table in the universe. because i did this before in the universe where database was ORACLE. In that case i haven’t create a dummy table.
Can you please provide some input how to see ALL in my prompt condition for the department