Click to See Complete Forum and Search --> : How to find last record on page?


LuckyVantuz
June 2nd, 2005, 12:34 AM
How can i find number of last record on page?

Madhi
June 2nd, 2005, 12:42 AM
Do you want to find the value or count?

LuckyVantuz
June 2nd, 2005, 12:50 AM
i want to find count

Madhi
June 2nd, 2005, 01:04 AM
Use three formula

Formula1 @Reset having the code
Numbervar count;
WhilePrintingRecords;
count:=0;

Formula2 @count having the code
Numbervar count;
WhilePrintingRecords;
count:=count+1;

Formula3 @Display having the code
Numbervar count;
WhilePrintingRecords;
count;

Place Formula1 at PageHeader and suppress
Place Formula2 at Details Section and suppress
Place Formula3 at PageFooter and dont suppress

LuckyVantuz
June 2nd, 2005, 01:37 AM
can i pass this max(count) parameter into Details Section? I want to suppress details if record is not last on page

Madhi
June 2nd, 2005, 01:43 AM
Not sure what you are asking. Do you want to show only the last record?

LuckyVantuz
June 2nd, 2005, 01:48 AM
i have detais a, details b sections in report and want to show details b section only for last record on page

Madhi
June 2nd, 2005, 02:11 AM
Goto section export
Select Details b
Nect to suppress option, there is button labelled x-2
clcik that button and write this code

not Nextisnull({FieldofDetailsB})

LuckyVantuz
June 2nd, 2005, 03:22 AM
not Nextisnull({FieldofDetailsB})

this code define last record in report, not in page