calc values from subreports

[Marco]

Hello.

I have a main report named A. Inside I have 3 subreports named 1; 2 and 3.
Each subreport as 3 columns.

I need that the values of subreport 3 are calculated from subreport 1 and 2.

So, my column 1 in Subreport 3 will be the difference between column 1 of
subreport 1 and column1 of subreport 2.

something looked like:

[subreport1].[column1]-[subreport2].[column1]

but this is not working for me.

Please help me.

Regards,
Marco

 

[Evi]

It looks like you're seeing the real data as that which is in the subreport
columns whereas it's in tables and queries.
Is there something that connects the 3 lots of data?

If yes, then you can put the data from subreport1 and that from 2 into a
query, connect them by the field they have in common and then perform your
subtract in the third column of the query. Your 3rd subreport can be based
on this latter column.

Or do you mean that sub3 should contain the Sum Total of the data in Sub 1
minus the Sum Total of the data in Sub2?

Evi

 

[Marco]

Hi.

My reports 1 and 2 have not a fixed column. but they load the values from
queries.

I already make it worked. If I open the reports in single different reports.
They are not working when I using it as subreports.

Regards,
marco

It looks like you're seeing the real data as that which is in the subreport
columns whereas it's in tables and queries.
Is there something that connects the 3 lots of data?

If yes, then you can put the data from subreport1 and that from 2 into a
query, connect them by the field they have in common and then perform your
subtract in the third column of the query. Your 3rd subreport can be based
on this latter column.

Or do you mean that sub3 should contain the Sum Total of the data in Sub 1
minus the Sum Total of the data in Sub2?

Evi

Hello.

I have a main report named A. Inside I have 3 subreports named 1; 2 and 3.
Each subreport as 3 columns.

I need that the values of subreport 3 are calculated from subreport 1 and 2.

So, my column 1 in Subreport 3 will be the difference between column 1 of
subreport 1 and column1 of subreport 2.

something looked like:

[subreport1].[column1]-[subreport2].[column1]

but this is not working for me.

Please help me.

Regards,
Marco