CODEWITHSUNDEEP
crystal-reportssubreport
Roby G.
Roby G.

Reputation: 105

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.

Upvotes: 0

Views: 301

Answers (1)

craig
craig

Reputation: 26272

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

Upvotes: 1

Related Questions