You don't give much info to go on.
In your record selection formula select the two years you want to report.
Group on the common field (ie. Officer Name)
Create two formulas, one for each year:
//{@Year1Name}
If DatePart("yyyy",{table.datefield} = {Year1} then
{table.officername} else ""
//{@Year2Name}
If DatePart("yyyy",{table.datefield} = {Year2} then
{table.officername} else ""
Place both formulas in the detail section and suppress the section.
In the section footer place two formulas each using the "Maximum" function on one of the {@Year#Name} formulas above:
//{@Year1NameMax}
Maximum({@Year1Name},{table.officername})
If this isn't what you are after, please give more information.
This is quite similar to what I wanted. I tried a similar report where I wanted counts of members for current year and previous year.
I did that using conditional running totals. I also need to show the difference between these two values(curr against prev year). I used a formula for that and got it working.
therefore, in my group footer, I have the 2 running totals for curr and prev year and the diff and I hide all other sections. Now the problem is, I need to sort the report based on the difference between those running totals in the group footer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.