Search code examples
crystal-reports

Retrieve record count of subreport in Crystal Reports

How can I retrieve the record count of a subreport from within the main report?

Solution

  • I think this is a dupe, but I'll answer anyway. :)

    You can create a formula field on the subreport which contains a shared variable. In the formula you'll set the shared variable to the value of the rowcount field in the subreport.

    Then in your main report you will need to create a formula with a shared variable that has the same name as the subreport and then return the value of the shared variable.

    Here are some links that may help. http://www.datamanagementgroup.com/Resources/TrainersTalk/trainerstalk_howto_share_subreport_data_with_main_report.asp http://www.ozgrid.com/forum/showthread.php?t=19034