1220426 - User is prompted to log on after modifying the Record Selection formula

SAP Knowledge Base Article - Public

1220426 - User is prompted to log on after modifying the Record Selection formula

Symptom

When modifying the Record Selection formula of a report that has been saved with data that contains linked subreports and shared variables, the user is prompted to log on to the database.

Cause

The issue has been identified and tracked under ID ADAPT00587101.

It affects the following:

  • BusinessObjects Enterprise XI Release 2
  • Crystal Reports XI Release 2
  • BusinessObjects Enterprise XI
  • Crystal Reports XI
  • Crystal Enterprise 10
  • Crystal Reports 10.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. With the update(s), this problem is resolved. (Note: Registry Key information below)

Registry Entry Information

-------------------------------

Crystal Reports and BusinessObjects XI Release 2

-------------------------------------------------

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\FormatOptions\IgnoreSharedVarStateInLinkedSubRpt

Type: STRING

Recognized Values: Yes, No

Default Value:

Creation Method: Hot Fix Installation

Crystal Reports and BusinessObjects Enterprise XI

--------------------------------------------------

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\FomatOptions\IgnoreSharedVarStateInLinkedSubRpt

Type: STRING

Recognized Values: Yes, No

Default Value: Yes

Creation Method: Hot Fix Installation

Crystal Reports and Crystal Enterprise 10

-----------------------------------------

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.0\Crystal Reports\FormatOptions\IgnoreSharedVarStateInLinkedSubRpt

Type: STRING

Recognized Values: Yes, No

Default Value:

Creation Method: Hot Fix Installation

Known limitations: Note that this fix will change the behavior of a report that has multiple subreport instances using the same linked parameter values but a different state of shared variable. The first datasource that matches the linked parameter values is returned; therefore, the shared variable values in the second subreport instance and next may be incorrect. For example:

Main report:

Group1: Country

Group2: Region

Shared variable: Shared NumberVar test := 0;

Subreport:

Link to field "Country" in main report

Shared variable: Shared NumberVar test := test+1;

Insert this subreport to Group2 Region

Before this HotFix is installed:

Group1 Canada

Group2

BC: subreport instance 1 - shared variable value "0"

ON: subreport instance 2 - shared variable value "1"

NS: subreport instance 3 - shared variable value "2"

After this HotFix is installed :

Group1 Canada

Group2

BC: subreport instance 1 - shared variable value "0"

ON: subreport instance 2 - shared variable value "0"

NS: subreport instance 3 - shared variable value "0"

Unless indicated otherwise, Critical Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

====================

Crystal Reports and BusinessObjects Enterprise XI Release 2

-------------------------------------------------

The latest update for this issue is available at the on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 11.5.6.507, dated 25/05/2006 (boXIr2win_chf.zip)
  • crw32.exe, version 11.5.6.507, dated 25/05/2006 (boXIr2win_chf.zip)

 

Crystal Reports and BusinessObjects Enterprise XI

--------------------------------------------------

The latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 11.0.0.2122, dated 25/05/2006 (commonXIwin_chf.zip)
  • crw32.exe, version 11.0.0.2122, dated 25/05/2006 (crXIwin_chf.zip)

 

Crystal Reports and Crystal Enterprise 10

-----------------------------------------

The latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 10.0.5.1406, dated 23/05/2006 (common10win_en.zip)
  • crw32.exe, version 10.0.5.1406, dated 23/05/2006 (cr10win_en.zip)

 

Monthly Hot Fixes and Service Packs

------------------------------------------

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.


Monthly Hot Fixes readmes and Service Pack readmes are available in the Downloads area of our web site.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CHF 587101 Crystal Reports Record Selection Subreport links , c2019618 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2