Working on a AP aging report this is the basic format
Vendor1
X1-bill billdate ageddays balance aged0-30 aged31-60...
X2-bill billdate ageddays balance aged0-30 aged31-60...
X3-bill billdate ageddays balance aged0-30 aged31-60...
billtot
Vendor2
Y1-bill billdate ageddays balance aged0-30 aged31-60...
Y2-bill billdate ageddays balance aged0-30 aged31-60...
Y3-bill billdate ageddays balance aged0-30 aged31-60...
billtot
OVERALL TOT
The report allows the end user to enter in a range that they want to see for instance I want to see all bills aged 35 to 40 days. Then conditionally suppress the days that don't fall into this range. I want to have a total for each vendor and then a total for the set of vendors returned. I have setup the funtions to do the reset if not inrepeatedgroupoheader that has been placed in the vendor header group. I have done the function to do the running total and placed it in the bill grouping. The placed the function in the vendor footer to show the total for each vendor. My problem is that the total for the vendor is adding in the balances for the records that have been suppressed. I only want the values that have been shown.
SUGGESTIONS...
Vendor1
X1-bill billdate ageddays balance aged0-30 aged31-60...
X2-bill billdate ageddays balance aged0-30 aged31-60...
X3-bill billdate ageddays balance aged0-30 aged31-60...
billtot
Vendor2
Y1-bill billdate ageddays balance aged0-30 aged31-60...
Y2-bill billdate ageddays balance aged0-30 aged31-60...
Y3-bill billdate ageddays balance aged0-30 aged31-60...
billtot
OVERALL TOT
The report allows the end user to enter in a range that they want to see for instance I want to see all bills aged 35 to 40 days. Then conditionally suppress the days that don't fall into this range. I want to have a total for each vendor and then a total for the set of vendors returned. I have setup the funtions to do the reset if not inrepeatedgroupoheader that has been placed in the vendor header group. I have done the function to do the running total and placed it in the bill grouping. The placed the function in the vendor footer to show the total for each vendor. My problem is that the total for the vendor is adding in the balances for the records that have been suppressed. I only want the values that have been shown.
SUGGESTIONS...