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