SCCM 2007 Reporting : How to change the Maximum Rows Returned in the Values List that is default set to 1000 rows

September 30, 2009 at 1:34 pm in AdminUi, ConfigMgr, ConfigMgr 2007, ConfigMgr 2007 R2, Reporting, sccm, SCCM 2007, SCCM 2007 R2 by Kenny Buntinx [MVP]

Report Viewer in Configuration Manager 2007 limits the number of rows returned to 1,000 rows when you click Values and the values list displays for a prompt. The maximum number of rows returned by the query for the prompt that populates the values list can be modified by creating a registry key and setting a value on site system computers that have the reporting point role.

IMPORTANT : Increasing the maximum number of rows for queries that return a large amount of data or for queries that are inefficiently written might cause performance issues when the values are displayed.

To do this and configure the number of rows returned in a values list

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

  2. On reporting points that run on a 32-bit operating system, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Reporting.

    On reporting points that run on a 64-bit operating system, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Reporting.

  3. Create a DWORD value named Values 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 prompt query that is run from this reporting point.

 

Hope it helps ,

Kenny Buntinx

Tweet about this on TwitterShare on FacebookShare on Google+Share on LinkedInPin on Pinterest