Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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.

replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question