Search code examples
crystal-reportssubreport

from subreport to main report

I have a crystal report that shows the data in this way:

code_price___qty

A__10.00____1

B__20.00____1

A__10.00____1

and in the footer I have a subreport that group by code and sum the price, so:

A___20.00

B___20.00

Now, I would like to have in the MAIN report the total of A + B, ie 40.00

how do I?

I can not take a value from the subreport to the main report..thanks in advance.

Solution

  • Steps:

    • Copy the summary field that is located in the group footer
    • Paste the summary field in the report-footer section
    • Remove the subreport; you can do all of this without one
    • Create a Running Total to calculate the value of A:

    enter image description here

    • Change "Field to summarize" to table.Price
    • The formula should be similar to {table.Code}="A"
    • Place field in report-footer section
    • Create second RT field for B