Crystal using parameter from universe

[Former Member]

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?

[Former Member · Accepted solution]

Hi Patrick,

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.

Step:-

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.

Regards,

Prashant.

[Former Member · Accepted solution]

Thanks these setting were in effect. The issue is Crystal tags the parameters in the report as static and does not refresh the cached LOV when executed.