subreport total to main

[marylally]

have a report with a subreport. The sub report is grouped by empid and payweek. the main report is also grouped the same way. I created a formua in the sub that passes to the main. On the main report it calculates correctly for each empid and payweek.

My problem is when I try to add the formula for each group and pass it to the main report I only get the second record from the payweek group.

Ex:

Empid 2007
Week 28 vpg $800.00
Week 29 vpg $1776.00

Total vpg $1776 it should be $2576.00

Please help!!!
THanks, Mary



MaryBeth


MaryBeth

 

[Bluejay07]

It seems to me like you are overwritting the value.

Check that you have something similar to:
TotalAmt = TotalAmt + EmpAmt;

If at first you don't succeed, then sky diving wasn't meant for you!

 

[IanWaterman]

Mary

Please do not double post

Ian

 

[marylally]

My apologies, I thought I had put it in the wrong category.
Mary

MaryBeth