1206835 - The Active X viewer only goes to page 65,535 when clicking Go to Last Page

SAP Knowledge Base Article - Public

1206835 - The Active X viewer only goes to page 65,535 when clicking Go to Last Page

Symptom

In Crystal Reports XI and Crystal Reports 10, when viewing a report with more than 65,535 pages in the Crystal Reports Active X Viewer, if the user clicks the Go to Last Page button, page 65,535 is displayed instead of the true last page.

Cause

This behavior occurs because the Go to Last Page button and ShowLastPage method of the SDK for Crystal Reports has a maximum limitation of 65,535 pages.

Resolution

To resolve the behavior

  1. Obtain the last record from the database.
  2. Customize the toolbar by adding a command button to go to the last record.
  3. Use the Crystal Report Viewer ShowNthPage method instead of ShowLastPage.

For example, use the following code:

// get the records count directly from the database using a stored procedure

totalPages = getTotalPages();

Protected void cmdLastRecord_Click(object sender, EventArgs e)
{
CrystalReportViewer.ShowNthPage(Convert.ToInt32(totalPages));
}
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->

Keywords

Active X, ShowLastPage, 65535, pages , 9480806 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2 ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1