Symptom
- Static list of values.
- Missing values from the list of values.
- Parameter does not display a dynamic list of values.
- List of Values in Crystal Reports based on a Universe is not returning all values.
- Reports that use a Universe as a data source does not display an updated List of Values (LOV) for the Universe prompts, when the report is refreshed.
Environment
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- SAP BusinessObjects Business Intelligence Platform 4.0
- SAP BusinessObjects Business Intelligence Platform 4.1
- SAP BusinessObjects Business Intelligence Platform 4.2
- SAP BusinessObjects Business Intelligence Platform 4.3
Reproducing the Issue
- In Crystal Reports, create a report on a Universe that have prompts.
- Add database fields to the report.
- When refreshing the report, it prompts for the parameters. Notice the List of Values available for the parameter.
- Add values to the backend data source.
- Refresh the report again, and notice the new values are not added to the parameter List of Values.
Cause
- When creating a report on a Universe that contains prompts, Crystal Reports create a parameter with a static list of values.
- The List of values is updated only in specific scenarios if it is configured to do so.
Resolution
- Universe prompt in Crystal Reports are converted to a parameter with a static list of values, but it is possible to have the list of values updated in some scenarios by setting the following options:
- In Crystal Reports, the report Query Panel option: "Always refresh List of Values", needs to be checked.
- In the Universe, the dimension on which the prompt is based, must have the following List of Values option enabled:
- Automatic refresh before use
- Export with universe
- On the SAP BusinessObjects Business Intelligence Platform server, the registry key: "AlwaysRefreshUniverseLOV" needs to be set to: Yes
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database
- The above options will update the Universe prompt list of values in the following specific scenarios only:
- In Crystal Reports:
- When opening the report in Crystal Reports, it will regenerate the prompt List of Values.
- When refreshing the report, it will not dynamically refresh the list of values, the list of values will be updated the next time the report is open.
- When opening the Query Panel of the report in Crystal Reports.
- In SAP BI LaunchPad, or the Central Management Console (CMC):
- When refreshing the report on-demand, the prompt list of values will be updated dynamically.
- But the Universe prompt list of values will still remain static in the following specific scenario:
- In SAP BI LaunchPad, or the Central Management Console (CMC):
- When scheduling a report, the prompt list of values will still be static. The list of values will be the static list of values stored in the report.
To manually update the list of values:
1. Refresh the report by using the Refresh Report button in the Central Management Console:
(Report Object > Properties Tab > Refresh Options subsection > Refresh Report; or
2. From Crystal Reports, save the report back to the SAP BusinessObjects Repository.
Successful report instances are saved with the LOV at the instances' scheduling time.
Workaround to see a dynamic list of values when scheduling:
1. In the Business Views Manager, create a List of Values.
( Note to create a List of Values you will need to create a Data Connection, Data Foundation, Business Element, Business Views )
2. In Crystal Reports, open the report based off the Universe, and edit the parameter that comes from the Universe.
3. Set the parameter to be dynamic, and select the Business View List of Values.
4. Save the report back to the SAP BusinessObjects Repository.
In this way, the List of Values will be dynamic when scheduled, because the List of Values comes from a Buisness Views and not the Universe.
- Known limitations:
- When checking those options, it may take longer to open a report based off a Universe in Crystal Reports designer or to view a report on-demand In BI LaunchPad. Performance is affected because the Web Intelligence Report Server is called when a report that is based on a universe is opened to fetch the pormpt List of Values, which adds more work to the server.
- The list of values will be limited by default to 1,000 values. To increase the limit, see the following SAP Knowledge Base Article:
1706213 - Parameter List of Value limited to 1000 values for report created off a Universe in Crystal Reports and viewed in SAP BI LaunchPad or CMC
- For the list of Universe functionalities supported in Crystal Reports, see the document:
Crystal Reports Universe Support ( Attached to the kbase )
- Known issues:
- Due to a regression issue, the list of values was static when viewed on-demand in SAP BI LaunchPad. The issue was tracked under the following SAP Note:
- 2038304 - The list of values in prompts in Crystal Reports based on a Universe is not refreshed while using SDK code, BI LaunchPad or the Crystal Reports
The issue is resolved in the following product updates and above:
- SAP BusinessObjects BI 4.0 and Crystal Reports 2011:
- Support Pack 09 - Patch 7
- Support Pack 10 - Patch 1
- Support Pack 11
- SAP BusinessObjects BI 4.1 and Crystal Reports 2013:
- Support Pack 04 - Patch 3
- Support Pack 05
Keywords
CHF 553899 LOV REFRESH BusinessObjects Enterprise Universe List of Values , c2019200 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Attachments
Crystal Reports Universe Support.pdf |