Skip to Content

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

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?

Former Member
replied

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.

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