page break and groups

rbuser

I would like to set page break on the fifth record from the tail (last
record in pipeline). How can i do it?

I have field "rec_no" in my pipline and dbcalc1 (which calculate records
count in report), but i can't use
dbcalc1 on event OnGetBreakValue of my group, because dbcalc1 is not
calculated yet when OnGetBreakValue fired.

Help me please.

With best regards,
Igor Spitkov

digitalmetaphors

Make a two pass report and find out which record is the 5th from the last by
the primary key value during the first pass. Then in the second pass,
manually set a group's break value to force a group break when the current
pipeline field value is the same as the stored last-5th record field value.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Good!
How can i find out which record is 5th from the last by primary key???

digitalmetaphors

Here is a down and dirty way to do it. Report.CachePages is true.
http://www.digital-metaphors.com/tips/NewPageOn5thFromLastRecord.zip


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thank you very much for your help, Jim.
Very useful example.

The problem is when we use RAP for creating such report. We have to count
records in Pipeline.
How can we do it? Should we use pass-through function?

With best wishes,
Igor Spitkov

digitalmetaphors

Yes, a pass through function will need to be used to get the record count.
We intentionally left this out of RAP because we didn't want your end users
to have this ability to call RecordCount, because it is a slow operation as
it requires the entire dataset to be traversed for the call.


Cheers,

Jim Bennett
Digital Metaphors