SAP Knowledge Base Article - Public

1218719 - Subreport returns no data after it is re-imported into the main report

Symptom

In Crystal Reports, an existing report is inserted as a subreport. Links to the subreport are created and then the subreport is re-imported.

When you now preview the report, the subreport returns no data.

There are no error messages and the subreport links appear fine.

Why does this behavior occur and how do you resolve it?

Reproducing the Issue

  1. Insert an existing report (as a subreport) into the main report.
  2. Right-click the subreport. Click Change Subreport Links. The Subreport Links dialog box appears.
  3. Link the main report to the subreport using any field.
  4. Click a parameter from the subreport in the bottom left corner of the Subreport Links dialog box. Click OK.
  5. Right-click the subreport in the main report
  6. Click Re-import subreport.

When viewing the record selection formula in the subreport, it has been modified to include an additional filter.

 

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

NOTE:

Do not clear the Select data in subreport based on field check box.

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

Resolution

This behavior occurs because re-importing a subreport may cause the record selection in the subreport to change. For example, an additional filter such as "{field} = {?PM-parameter}" is added to the record selection formula.

This is a known issue and has been tracked under Track ID ADAPT00073557.

To resolve this behavior, use the following steps:

  1. Right-click the subreport in the main report. Click Edit Subreport.
  2. Go to the Report menu and click Selection Formulas > Records.
  3. Remove any extra filters that were added when the subreport was re-imported to the main report.

 

=======For BusinessObjects XI Release 2==============

In BusinessObjects XI Release 2, this issue has been fixed with a Critical Hot Fix.

Hot Fixes or Service Packs address this issue as indicated below. With the update(s), the linked subreport parameters are not added to the selection formula anymore.

Known limitations: It can happen that an independant selection formula condition gets duplicated, but the resulting SQL will still be the same.

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.

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

BusinessObjects XI Release 2 for Windows
--------------------------------------------

For BusinessObjects XI Release 2, 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):

  • crw32.exe, version 11.5.2.408, dated 2/15/2006 (boXIr2win_chf.zip)

 

BusinessObjects XI Release 2 for Solaris
------------------------------------------
For BusinessObjects XI Release 2 for Solaris, the latest update for this issue is available on the Downloads area of our web site.

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

SUB SUB-REPORT BLANK REIMPORT IMPORT CR 8.5 EMPTY Crystal Reports subreports parameters select expert import subreports , c2017606 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 10.0