I know this question has been asked many times before, but I can’t seem to get this to work no matter what I read. I know you can use CreateTotals and the group totals to create subtotals based on groups like posting date, customer, etc… but I’ve never been able to get this to work. Each time I try to enter the GroupTotal fields, place a group total section on the report and insert the field that I want to be calculated on the actual report it just ends up showing the value of the last record. I’ve tried a variety of tutorials, and I still end up with the same results (I’m feeling a little silly right now). The CreateTotals function yeilds the same results.
I have a sales header table connected to the sales line table. What I want to do is create two subtotals: one that sums up the total revenue of each invoice, and another subtotal that sums up the total revenue for each customer. I have the report sorted by customer, and invoice number. Solutions that deal with C\AL coding are welcome. I actually find it easier and more flexible to use code than to use built in NAV reporting functions.
I am using NAV 5.0 SP1.
Help is much appreciated.