Complicated report - calculations on the fly

[digital]

Hello Everyone,

I have a weird sittuation that I need to solve.

I have a report which has a subreport, and those 2 show the following info:

(see attachments)

The report shows records of every export that took place for a preselected product.
It shows the original imported value - for example 10.000 products.

Then, it shows the products components (dont worry about weird looking figures), and the STATE (STANJE) of each component that staid in our company. So, we imported 10.000, exported once 1.880, and then, 120 pieces.

The report should display the "STANJE" (STILL IN THE COMPANY) value right, but I dont know how to get it done.

This is what it looks like now:

page 1, record 1
IMPORTED: 10.000
EXPORTED: 1.880
STATE: 120

page 2, record 2
IMPORTED: 10.000
EXPORTED: 120
STATE: 1.880

On the pages that follow the first page (each record that follows), the numbers should be subtracted from the previous record as follows:


IMPORTED: 10.000
EXPORTED: 1.880
STATE: 120

IMPORTED: 10.000 minus last exported number (1.880)
EXPORTED: 120
STATE: 0

I really really need this solved..

Thank you all for any tips or ideas.

 

[Rich]

Use the RunningSum property of a calculated control, set the RunningSum property to OverAll

 

[digital]

report scheme

Attached is the report scheme of what I get and what I need to get.

I think I have to use VBA and onformat events to get this done.

any ideas?