SMS 2003 - Configuration - Increasing Rows Past 10,000 in Web Reporting
It is inevitable that every SMS Administrator runs into a web report which will not yield the total of the query's request, giving only 10,000 rows of information. Here is the resolution for this from Microsoft:
"You can change the limit by modifying the registry on the reporting point machine. Under the HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting key, add the DWORD value Rowcount and assign it the value for your desired maximum limit. The maximum row count in decimal is 32767. If you need to return more than 32,767 records, you can set the row count to 0xffffffff hexadecimal, which will return all rows. However, this significantly increases the workload on the SMS site database. If you experience problems displaying the values in reports, add the Values Rowcount registry key by using the same settings as above.
Be aware that if you increase this value, you might also need to adjust the AspBufferingLimit setting. For more information about changing the AspBufferingLimit setting, see the FAQ “When my Web reports contain a column that has more than 5,000 records I get an IIS error 500 on my IIS 6.0 reporting point. How do I fix this?” earlier in this document."
I've changed mine to FFFFFFFF and it works fine, albeit it somewhat slow, as indicated above. Here is the link to the Q & A:
http://www.microsoft.com/technet/sms/2003/library/techfaq/tfaq10.mspx