Group Total Problems

[denileigh]

Hello all,

I have a report that has 3 subreports in it (expenses, hours, and costs) per job.
I have them hidden and have it grouped by customer then by job as I've been requested to create a summary report showing the above in groups.

It's running and calculating fine however in the group (by customer) footer I can't get the totals to work. For example, the job grouping total is Text 128 so in the footer I want to calculate that by customer and I enter =Sum([Text128]). When I run the report though it pops up and asks me for a Text128 value??

Example

Customer

Item Item Number Job Expenses Labor Cost(Calculated here in box Text128) Billing Profit

In the Customer footer
=Sum([Text128])


How do I do that? Text 128 is calculating just fine in the detail. Not in the footer.

 

[Beetle]

You can't reference an unbound control (in this case Text128) when performing a calculation in the footer. You need to Sum the original calculation. For example, if the Control Source in Text128 is =[Expenses]+[Labor], then the Control Source in the footer should be;

=Sum([Expenses]+[Labor])

 

[denileigh]

Ohhhhhhhhhhhhhhhhh! TY so much! I'll try it!

 

[denileigh]

It's not working. Is it because it's an ifthen statement being pulled down from a subreport? =IIf([InvoiceExpSun].[Report].[HasData],[InvoiceExpSun].[Report]![Text19],0)