Crystal Report how to print last record together with the footer to the lastpage if the last record is not coming in the last page

1,050 views
Skip to first unread message

gir...@cdactvm.in

unread,
Jun 24, 2009, 4:30:59 AM6/24/09
to Rainforestnet Crystal Reports Exporter
sir,
Kindly help me in the problem below.

My requirement:
The Group footer alone should not come in the last page, in that case
the last record in the page before the last one should be printed
along with the group footers in the last page.

I tried with the following formula in the formula section of the next
page before option
if ((TotalPageCount = 1) and (OnLastRecord = TRUE)) then FALSE else
if ((TotalPageCount > 1) and(PageNumber <> TotalPageCount)) then
(OnLastRecord = TRUE) then TRUE else FALSE;

In this case , evenif the total print can accomodate in a single page
the last record will be shifted to the next page together with the
group footers. ie In every case the last record will be shifting to
the last page together with the footers even if it can accomodate in
the same page.

Then I tried with the other option

the formula is modified as below

if ((TotalPageCount = 1) and (OnLastRecord = TRUE)) then FALSE else
if ((TotalPageCount > 1) and(PageNumber = (TotalPageCount - 1)))
then (OnLastRecord = TRUE) else FALSE;

In this case if the total print can accomodate in a single page, it is
printing correctly,
But when the case when the footer alone will come in the last page,
the last record is missing in the page but the last one and the same
record is missing in the last page also.

kindly help me in this regard.

regards
girijadevi

bij...@gmail.com

unread,
Feb 4, 2013, 12:17:09 AM2/4/13
to rainforestnet-cryst...@googlegroups.com, gir...@cdactvm.in
same is my problem

i didn't get any definite answer for this problem

if you got then please share

regards,
biju
Reply all
Reply to author
Forward
0 new messages