Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 01:19 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.