assuming you want to total the ValueOhHand field
:-k
View Sections add a Item (FOOTER) should be 8
Add a variable "GrandTotal" type decimal (or whatever name you want)
on the PreDataItem of ITEM add
OnPreDataItem()
CurrReport.CREATETOTALS(ValueOnHand);
view Sections & on
OnPostSection() if Item Ledger Entry, footer 7
GrandTotal := GrandTotal +ValueOnHand;
Add a textbox in the item footer8 with sourceexp = grandtotal
I am trying to get totals of the totals based on entered filters for instance.
Filters set: Date 110108..113008
NO. A..C
Entry Purchase
Results
Item A
11/01/08 Purchase 10
11/15/08 Purchase 10
Total of Entries 20
Item B
11/2/08 Purchase 5
11/16/08 Purchase 10
Total of entries 15
What I need is to total A and B
A 20
B 15
Grand total of purchases is 35 for the period filtered.
I would need it to total off of the total of entries. As this report has several filters from the Item ledger entry table that are being used. I could create a report just for purchases and use Create total from Purchases (QTY) from Items but would rather make this report wokr from the total of entries so that it would me multi functional.
I really appreciate the help. I am not sure if I am being as clear as I need for my requirements. I just want this report to take all the Item subtotals and give me a grand total of all the subtotals of the report. I need to see the totals for each group but then at the end I need the total. It will give me the total count of every item that I sold or purchased as well as other adjustments but only when I filter for them.
i doesn't know this report, but totaling is ever the same.
So as Harry ask, what do you want to total?
For totaling you can use the property TotalFields and the function CurrReport.createtotals(Field) in onPreDataItem and GroupFooter / GroupHeader
the link above is to a report numbered 50062 - so if you do not have a 50062 you can import it and take a look at it without writing over the original report.
For type Purchase i'll restart.
Add a variable GrandTotalPurchase type decimal
View Sections-> click On Item LedgerEntryFooter(8) hit f9
OnPostSection() add
I imported your report but received Field no 5403 is not defined in the Item Ledger Entry table.
Do I need to setup different sourceExp for each entry type?
If you run your report with a filter of sales will it give you a grand total for all the items that you sold for a defined date? As well as give you a subtotal of each item?
I imported your report but received Field no 5403 is not defined in the Item Ledger Entry table.
you might have to adjust the dataitemtableview property of the item ledger entry dataitem
from SORTING(Item No.,Variant Code,Drop Shipment,Location Code,Bin Code,Posting Date)
5403 is bin code. - What's you second key? try that one
Do I need to setup different sourceExp for each entry type?
If you run your report with a filter of sales will it give you a grand total for all the items that you sold for a defined date? As well as give you a subtotal of each item?
Answers
:-k
View Sections add a Item (FOOTER) should be 8
Add a variable "GrandTotal" type decimal (or whatever name you want)
on the PreDataItem of ITEM add
OnPreDataItem() view Sections & on
OnPostSection() if Item Ledger Entry, footer 7 Add a textbox in the item footer8 with sourceexp = grandtotal
http://www.BiloBeauty.com
http://www.autismspeaks.org
Filters set: Date 110108..113008
NO. A..C
Entry Purchase
Results
Item A
11/01/08 Purchase 10
11/15/08 Purchase 10
Total of Entries 20
Item B
11/2/08 Purchase 5
11/16/08 Purchase 10
Total of entries 15
What I need is to total A and B
A 20
B 15
Grand total of purchases is 35 for the period filtered.
I would need it to total off of the total of entries. As this report has several filters from the Item ledger entry table that are being used. I could create a report just for purchases and use Create total from Purchases (QTY) from Items but would rather make this report wokr from the total of entries so that it would me multi functional.
An I on the wrong track here
http://www.BiloBeauty.com
http://www.autismspeaks.org
Did the pic not show you totalling of subtotals? I thought it did.
Have you tried it or do you want me to create the report?
http://www.BiloBeauty.com
http://www.autismspeaks.org
So as Harry ask, what do you want to total?
For totaling you can use the property TotalFields and the function CurrReport.createtotals(Field) in onPreDataItem and GroupFooter / GroupHeader
Regards
I attached a sample report that totals the Value you can add qtyonhand or anyother field you want to total up.
http://www.BiloBeauty.com
http://www.autismspeaks.org
http://savatage99.googlepages.com/Repor ... ailwit.fob
http://www.BiloBeauty.com
http://www.autismspeaks.org
For type Purchase i'll restart.
Add a variable GrandTotalPurchase type decimal
View Sections-> click On Item LedgerEntryFooter(8) hit f9
OnPostSection() add On the newly created Item (FOOTER) add a textbox with sourceexp = GrandTotal Purchase
http://www.BiloBeauty.com
http://www.autismspeaks.org
Do I need to setup different sourceExp for each entry type?
If you run your report with a filter of sales will it give you a grand total for all the items that you sold for a defined date? As well as give you a subtotal of each item?
you might have to adjust the dataitemtableview property of the item ledger entry dataitem
from SORTING(Item No.,Variant Code,Drop Shipment,Location Code,Bin Code,Posting Date)
5403 is bin code. - What's you second key? try that one I believe so!
http://www.BiloBeauty.com
http://www.autismspeaks.org
If I want to total the cost, do I do the same steps and change purchase to cost?
GrandTotalCost or GrandTotalValue or GrandTotalQuantity, etc
totaling any field you want.
Adding the cost
new Variable called GrandTotalCost
OnItem Ledger Enter Footer (8) (view sections)
OnPostSection()
GrandTotalPurchase := GrandTotalPurchase +Quantity;
GrandTotalCost := GrandTotalCost + "Adjusted Cost"; <<add!
on the footer add a new textbox with GrandTotalCost as the source exp.
http://www.BiloBeauty.com
http://www.autismspeaks.org
can you see the c/al code already there
add this, is "Adjusted Cost" the name of the field you want to total?
Here's an updated report
http://savatage99.googlepages.com/Repor ... htotal.fob
I'm must be in a giving mood today!
http://www.BiloBeauty.com
http://www.autismspeaks.org
http://www.BiloBeauty.com
http://www.autismspeaks.org
Thank you very much for your time and patience on this report.