Crystal using parameter from universe
When creating parameter in a Crystal report using a universe the LOV becomes static. This is a weak limitation in the tool. Has anyone found a work around so that the parameter is dynamic as it was intended and the parameter LOV is refreshed each time the report is executed?
Universe-based Crystal reports in BusinessObjects Enterprise XI and XI Release 2 can have dynamic parameters based on Universe list-of-values (LOV) objects. Crystal Reports only refreshes Universe LOV objects when the Universe is changed.
The two new methods for causing a LOV object to be refreshed in Crystal Reports are:
1. Refresh at every use. This simple option ensures the LOV presented to users is always up-to-date when viewing a report object. It doesnu2019t apply to scheduling, so this option doesnu2019t help when viewing instances of scheduled reports.
2. A new BusinessObjects SDK option has been introduced, allowing developers to write scripts or applications to control when LOV objects are updated. Applications can be triggered or scheduled in the BusinessObjects environment in a number of ways. Sample code is provided, showing how a group of reports might be scheduled to be updated.
Refreshing Universe LOV Objects
To ensure the Universe prompt is refreshed before each use, be sure to edit the object properties in the Universe Designer and set the Automatic refresh before use option.
Right click the object.
Select the Properties tab.
Enable the Automatic refresh before use option
Crystal Reports will also update cached LOV objects when the report query is edited in the Crystal Reports Universe query panel.
I hope this information helps you.