Export (0) Print
Expand All

How to Configure the Maximum Rows Returned by a Report Query

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

Report Viewer in Configuration Manager 2007 limits the result set returned by a report query to 10,000 rows. The maximum number of rows that are returned when running a report query can be modified by creating a registry key and setting a value on site system computers that have the reporting point role.

noteNote
Increasing the maximum number of rows for queries that return a large amount of data or queries that are inefficiently written might cause performance issues when the report is run.

Use the following procedure to configure the maximum number of rows returned by a report query.

To change the number of rows returned by a report query

  1. Open the Registry Editor on the reporting point computer.

  2. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting.

  3. Create a DWORD value named Rowcount, and then set its value to the number of rows that you want returned in the report query. If you want to return all rows, set the value to 0xffffffff, which is the hexadecimal equivalent of –1.

    The configured number of rows is returned by any report query that is run from this reporting point.

    noteNote
    If you set Rowcount to a number that is not valid (such as 0 or a number less than –1), Report Viewer returns the default maximum of 10,000 rows.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft