Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

main report not adding subreport totals by groups together

Status
Not open for further replies.

marylally

Technical User
May 15, 2009
37
US
I 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
 
You said there were only two groups--therefore there can be no group footer 3.

-LB
 
I added another section, should I delete it?

MaryBeth
 
Adding another section does not create a GF3. There would be a letter extension: a, b, c. So rewrite your post that explains where things are and reference the correct sections please.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top