Skip to Content

enable repository refresh property

Is there an InfoObject property that represents the Enable Repository Refresh option (that is available when a Crystal Report is saved to the Repository), that could be queried using the query builder (/AdminTools)?

SELECT si_?? FROM ci_infoobjects WHERE si_id=111111<br>
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 06, 2017 at 03:16 PM

    No, there's not. That's a property of the "save" functionality in Crystal, not a property of a report or within the BI Platform.

    What are you trying to do?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • I would like to be able to identify all of the RPTs that don't have this setting, then set this to true for those that don't.

      Is this property exposed such that it can be read/set by RAS?

  • Dec 06, 2017 at 04:41 PM

    This is not a setting on any report. Instead, it's an option that's available at Save time and only affects the current save action and any subsequent save action during the session in Crystal. The value is not saved anywhere in the CMS database.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 18, 2017 at 01:41 PM

    There does, in fact, appear to be an field that stores this information (v14.2.4.2410): SI_REFRESH_OPTIONS.

    These are its values if you toggle each checkbox individually:

    • None = -384
    • Title = -383
    • Description = -382
    • Keywords = -128
    • Current and default parameter values = -380
    • Record selection formula = -376
    • Group selection formula = -368
    • Printer options = -320
    • Default database logon information = -352
    • Use Object Repository when refreshing report = -384
    • All = -1
    Add comment
    10|10000 characters needed characters exceeded