Sorry DBlank, I didn't realize anyone had responded to this thread.
Originally posted by DBlank
What do you mean by a RT that counts the final record? What are the RT set up options or are you using variables that are counting/displaying?
I have several manual RT's in my report, placed in group footers. They look at the date in the group footer and count the group as "+1" if the date falls within a certain year (ex. 2004). I have separate RT's for each calendar year so that each group is accounted for in one of the RT's. Only one of the RT's, then, actually counts the very last group. That particular RT is the one that is causing the problem.
My RT looks like this:
-----------------------------------------------------------------
WhilePrintingRecords;
Global NumberVar CY1HiresRT;
If PreviousIsNull({@Lawson ID})=True and totext({@Group - Year of Start Date},0,"")={@CY1_Name} Then
CY1HiresRT:= 1
Else
If totext({@Group - Year of Start Date},0,"")={@CY1_Name} Then
CY1HiresRT:= CY1HiresRT + 1
Else
CY1HiresRT:= CY1HiresRT
;
------------------------------------------------------------------
When I display the RT in the group footer, it shows a total of 112. When I place the RT in the report footer, it shows a total of 113.
I hope this helps give a clearer understanding of what's going on. Any help is appreciated!
Edited by kemigirl - 19 Jun 2009 at 2:01pm