SAP Knowledge Base Article - Public

1266331 - Subreport Not Returning Right Subtotal

Symptom

Crystal XIr2 - I have a crystal report with a subreport in it that I can't get to return the right subtotal for the

group.

Cause

- Subreport links not correctly linked to subreport fields

- table linking in subreport incorrect

- date vs date/time field in subreport

- grouping in subrport incorrect

Resolution

1 - ensured that sub-report links were correctly pointing to subreport database fields

2 - Subreport link on a DATE type parameter in main report so created a formula in sub-report changing a date/time field to a date type using the DATE function

3 - Removed redundant and un-needed table linking in sub-report

4 - Validated record selection formula in subreport to ensure it was using ?Pm- type parameters (passed in from the main report)

Keywords

subreportshared variablesubtotaltable linking , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI