Subreport data used in formula

[stoopers]

I am using Crystal 11.0 and iScala 2.02 (financial system) and an external access DB. I have created a report in Crystal using project information from the iscala system to get total rev and expenses by project:
Project number
account number
dept number
amount
transaction date

From the access database - I would like to bring labor hours by project and the labor $$ associated with each project.

I have created a subreport with this information and have linked it to the main Crystal report by Project number. How do I include the labor $$ in a formula for total expenses by project?

 

[lbass]

In the subreport, create a formula and place it in the subreport footer:

whileprintingrecords;
shared currencyvar labor := <your labor$$ calculation>;

Then in the main report, in a section below the one in which the subreport is executing, add a formula:

whileprintingrecords;
shared currencyvar labor;
labor + {table.othercosts}

-LB

 

[stoopers]

Thank you so much - I was finally able to bring in the labor$$..

One last issue - I have the subreport in Group Footer 1A, the formula for the total expense in Group Footer 1B...I have tried to "display" the shared variable in Group Footer 1B to no avail.....I used the following formula:

whileprintingrecords;
shared currencylabor;

Am I missing something....

 

[lbass]

The formula should be:

whileprintingrecords;
shared currencyvar labor;

-LB