Maximum number of items in report

Specifies the maximum number of items that can appear in an Item Detail report or Production Run report. The default is 500,000.

To remove the limit on the number of report items, upgrade your reporting server to SQL Server 2008 with Cumulative update package 1 or later. This package resolves a number of out-of-memory issues that can occur when you generate reports on large numbers of items.