Skip to Content
0
Former Member
Oct 06, 2008 at 01:41 PM

Crystal Reports XI R2 Multi Value Prompt from Business View (LOV)

12 Views

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.