Hi Colin,
Yes I think you have the answer. With Alt-F7 the record pointer does not change from the current record, however when you do a search the record pointer moves through each record to see if it matches the search criteria. Consequently if you use a Shift F7, when the Final Footer is executed the record pointer points to the last record in the current index. Similarly if you have a reverse soft then once the first matching record is found it will keep moving forwards to the last record (in reverse) order in the index, ie the first record. If you wish to stop the Record pointer being moved use Stop [Sub]Report if 0 is in Report Variable X in the Report Body and the record pointer will not move from this record, and hence fields in this record will also be directly accessible in the Final Footer Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Colin Roberts Sent: Friday, 29 April 2011 1:55 PM To: [email protected] Subject: [Dataperf] Record Total in report varies based on Print method ?? Apolgies - me again. If search is backward it prints the total from the previous record. If search is forward it prints total from the following record. Obviously the Total being in the final footer with search conditions is seeing the record roll on to the prev/next one before it can access that data. I think I need to capture the info earlier in the report with maybe a variable report condition rather than from the final footer which is how I think I used to do it before adding some sub-reports sometime after 2004 and then thought I would simplify it. - Wrong Call :-( Sorry for troubling you all. Regards Colin
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
