calc values from subreports

  • Thread starter Thread starter Marco
  • Start date Start date
M

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
 
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
 
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







Evi said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top