Skip to Content
avatar image
Former Member

Pass data from Subreport to Main report for calculation many to one

Hello -

I need to pass data from the subreport to the main report for calculation. I am familiar with shared variables and have used them often, however it was always a one to one relationship. In my main report I have a part and a shipped quantity. In the subreport, linked by the part, I have multiple component parts each with a qty per. I need to multiply the qty per for each component part in the subreport with the main report part shipped quantity.

Main report Part# 111 - Shipped Qty 2

Subreport part# 111a- qty 1 per (need to multiply by shipped qty for Part# 111) = 2 shipped

Subreport part# 111b- qty 2 per (need to multiply by shipped qty for Part# 111) = 4 shipped

Thanks,

Helen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers