Skip to Content
0

enable repository refresh property

Nov 20, 2017 at 04:56 PM

50

avatar image

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>
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dell Stinnett-Christy Dec 06, 2017 at 03:16 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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?

0
Dell Stinnett-Christy Dec 06, 2017 at 04:41 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
craig buchanan Dec 18, 2017 at 01:41 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded