How to limit the number of rows to show in the table?

[jefftiga]

The results overlaps the table. I want to limit the data it fetch from the db. how to do this?

[TimSchofield]

Rather than limit the rows you take from the DB, you need to change the point at which it throws a new page.

Tim

[jefftiga]

Rather than limit the rows you take from the DB, you need to change the point at which it throws a new page.

Tim

where and how can i change it?

[TimSchofield]

Well in PrintCustStatements.php you have the lines:
if ($YPos-$line_height <= $Bottom_Margin){
/* head up a new statement page */
$PageNumber++;
$pdf->newPage();
include ('includes/PDFStatementPageHeader.inc');
} //end if need a new page headed up
at round about line 259. In your case the bottom margin is bigger I think, so you need to increase the size of the $Bottom_Margin variable, or just change the condition line to make the new page call come earlier.

Tim