cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rick,

As you have created Lov's in BusinessView Manager then you can get all values.

You can schedule the lov's at the Business view level and verify the LOV's which are created.

When you create parameters at report level you can get multiple values or list of all values in the report.

In the parameter We can allow multiple values.

Let me know if you have any other requirement.

Regards,

Naveen.

Answers (0)