Skip to Content

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

Aug 22, 2017 at 03:44 PM


avatar image

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



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers