Any way to carry Group Totals to New Report 1

[nsanto17]

I am working on something for my accounting department.

I need to carry over group totals from Report1 to Report2 without carrying over all of the formulas.

Does anyone know of way this can be done? Does inserting a Sub-Report accoplish this?

Thanks

nick

 

[DrHabi]

Yes, you will have to use subreports and use

shared numbervar grandtl:=SUm({table.field})
in the sub report then grab to shared variable in the main report

shared Numbervar grandtl;

and then you cna use that value for calculations

 

[nsanto17]

I am trying what you have suggested and it seems it will do what i need it to.

Just to be sure is this how its done????

in the sub-report i create a formula and enter
Shared NumberVar Grandtl:=Sum({table.field})

Then in the main report I create another Formula and enter

Shared NumberVar Grandtl;

Then place that on my report???

Thanks

Nick

 

[DrHabi]

yes but there can be a few issue regarding how this amount is used. If you are putting the subreport in a group then you will have to reset the value after each new set. Otherwise if you are just bring it into the main report,
then you can use it in formula:

shared numbervar grandtl;

Sum(table.fields) + grandtl

most likely you will have to refernece this value after your subreport in the main report.

 

[nsanto17]

Ok great... I got it working... Thanks for your help. Here is your star...

I am worried that for what i need this may be too complex.

I have a Finincial statement and need to carry over all of the group names and totals to a Balance Sheet (sub report)

There will end up being about 20 or 30 shared varables that will need on the sub report.