<img src="https://secure.perk0mean.com/176329.png" alt="" style="display:none;">

    Crystal Reports Technique: Passing Data from Subreport to Parent

    =crystal reports technique subreport parent

    On a couple of occasions, we've needed to sum data or concatenate a string within a Crystal Reports subreport, and then pass the data back to the parent report for display. The key to doing this is passing the data in a variable within a Formula Field that exists on both the Crystal Reports subreport and parent report. Follow our method of passing data from subreport to parent report.


    How to Pass the Data

    In the subreport, do all your necessary calculations in a Formula Field, which should be added into the Report Footer. Add the following code into the Formula Field:

    Shared CurrencyVar grandTotal := {@calculatedSum};


    The Shared qualifier allows you to pass the data through a declared variable. We declared the variable as a CurrencyVar, but you will need to declare your variable with the appropriate type. Other types are StringVar or NumberVar.

    You can set the variable to a summed value or another Formula Field.

    Now in the parent, add a Formula Field with the same name. Add similar code to access the variable and make sure the variable name is the same.

    Shared CurrencyVar grandTotal;


    Now drag the Formula Field onto your report.

    Need more help when it comes to reporting? Don't hestitate to get in contact with one of our expert consultants today, and click here to learn more about Epicor ERP reporting! As an Epicor Platinum Partner, Datix has all the answers to your ERP needs. 


    TJ McDowell

    TJ McDowell

    Datix's EVP of Software Development, TJ, is a veteran development leader with experience in ASP.NET, SQL Server, Project Management, and many other valuable technologies. TJ possesses the ability to quickly transform technical requirements into powerful business outcomes.

    When Manufacturers Should Use Epicor CRM or Best of Breed CEOs Share Their Customer Service Musts

      Contact Us


      see all

      Recent Posts