Hi,
I have a report that has two totals for tonnage amount. One totals the the total tons for a given month and the other is the total for the year (all the months for that year summed up). The totals are calculated through a function (because there are some additional calculations needed to find the tonage) and then after the function is ran it sets the tonnages back to zero. This works fine if I run through the report page by page, however, if I skip to the end and work my way backwards, the year tonnage only calculates the monthly tonnages that are on the same page and ignoring any that are on the previous page. I have thought of keeping this group together but the end-user does not like it because it wastes paper. HELP!!!
Thanks in Advance
I have a report that has two totals for tonnage amount. One totals the the total tons for a given month and the other is the total for the year (all the months for that year summed up). The totals are calculated through a function (because there are some additional calculations needed to find the tonage) and then after the function is ran it sets the tonnages back to zero. This works fine if I run through the report page by page, however, if I skip to the end and work my way backwards, the year tonnage only calculates the monthly tonnages that are on the same page and ignoring any that are on the previous page. I have thought of keeping this group together but the end-user does not like it because it wastes paper. HELP!!!
Thanks in Advance
