on 10-06-2008 2:41 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.