HI All,
My Crystal Report / Business is functioning correctly except for Multi-Value Prompt default.
I have Created a Business View Prompt and populated the LOV by using a command:
Select Department
from MV_RESULTSSUMMARY
UNION
Select '..ALL'
from MV_RESULTSSUMMARY
I get a LOV of the Department with ...ALL added into the LOV.
I need to be able to have a Multi Value field in Crystal Reports XI R2 to have a default value of ...ALL or have it accept Blank or Nulls as ALL Records.