P
PHisaw
Hi,
I'm hoping someone will help with some calculations I'm trying to work out
on a main and subreport. I will list what I have:
Subreport - rSlspSubreport
Fields - Qty; Model; QuoteTotal
Report Footer - text box "txtQuoteTotal"
Control Source: =Nz(Sum[QuoteTotal])
Main Report - rSalesman
Grouped by Salesman (Header & Footer)
Salesman Footer Text Box "txtGrpTotal"
Control Source: =rSlspSubreport.Report!txtQuoteTotal
Salesman Footer hidden text box "txtRunTotal"
Control Source: =[txtGrpTotal]
Running Sum: Over All
Report Footer text box "txtGrandTotal"
Control Source: =[txtRunTotal]
List of records from subreport query:
QuoteNumber QuoteTotal
7011 1281.00
7011 1100.00
7012 20645.00
7013 2751.00
For the report view, this is what I get:
Page 1 Bob's quotes
Quote # 7011
Qty 1 Description 1281.00
Qty 1 Description 1100.00
subrpt footer txtQuoteTotal 2381.00
main rpt slsp grp txt RunTotal 2381.00 main rpt slsp grp
txtGrpTotal
Bob's Total 2381.00
Page 2 David's Quotes
Quote # 7012
Qty 1 Desc 20645.00
subrpt footer txtQuoteTotal 20645.00
Quote # 7013
Qty 1 Desc 2751.00
subrpt footer txtQuoteTotal 2751.00
main rpt slsp grp txtRunTotal 5132.00 main rpt slsp grp
txtGroupTotal
David's Total 2751.00
Report Total 5132.00
As you can see, it is not including the amount 20645.00 in the calculations
for David nor for the overall report total.
I'm sorry for the length of the message. I wanted to clarify, hopefully, as
much as I could. If anyone can give advice as to what I'm doing wrong, it
would be greatly appreciated!
Thanks in advance,
Phisaw
I'm hoping someone will help with some calculations I'm trying to work out
on a main and subreport. I will list what I have:
Subreport - rSlspSubreport
Fields - Qty; Model; QuoteTotal
Report Footer - text box "txtQuoteTotal"
Control Source: =Nz(Sum[QuoteTotal])
Main Report - rSalesman
Grouped by Salesman (Header & Footer)
Salesman Footer Text Box "txtGrpTotal"
Control Source: =rSlspSubreport.Report!txtQuoteTotal
Salesman Footer hidden text box "txtRunTotal"
Control Source: =[txtGrpTotal]
Running Sum: Over All
Report Footer text box "txtGrandTotal"
Control Source: =[txtRunTotal]
List of records from subreport query:
QuoteNumber QuoteTotal
7011 1281.00
7011 1100.00
7012 20645.00
7013 2751.00
For the report view, this is what I get:
Page 1 Bob's quotes
Quote # 7011
Qty 1 Description 1281.00
Qty 1 Description 1100.00
subrpt footer txtQuoteTotal 2381.00
main rpt slsp grp txt RunTotal 2381.00 main rpt slsp grp
txtGrpTotal
Bob's Total 2381.00
Page 2 David's Quotes
Quote # 7012
Qty 1 Desc 20645.00
subrpt footer txtQuoteTotal 20645.00
Quote # 7013
Qty 1 Desc 2751.00
subrpt footer txtQuoteTotal 2751.00
main rpt slsp grp txtRunTotal 5132.00 main rpt slsp grp
txtGroupTotal
David's Total 2751.00
Report Total 5132.00
As you can see, it is not including the amount 20645.00 in the calculations
for David nor for the overall report total.
I'm sorry for the length of the message. I wanted to clarify, hopefully, as
much as I could. If anyone can give advice as to what I'm doing wrong, it
would be greatly appreciated!
Thanks in advance,
Phisaw