Monday, 4 February 2013
Just recently I found a few of our larger reports weren't displaying/returning all rows properly so a call went into MS with the following resolution:
Unable to view complete Reports. Row count limited to 2035
1> ASP buffer Limit was set to false
2> Buffer limit was using default settings.
1> Enable the Buffer Limit to true.
2>. On all computers on which a reporting point is enabled, run Regedt32 or
3. Navigate to the following registry key:
or on a 64 bit Operating System:
4. In the Reporting key, create a DWORD value named Rowcount, edit this value, and enter ffffffff for this new entry.
5. All rows should now be returned by any report query run from this reporting point.
Open command prompt to C:\Inetpub\AdminScripts and run the following command:
Cscript adsutil.vbs set w3svc/aspbufferinglimit "209715200"
6. Restart the IIS and SMS_Reporting services.
Posted by Doc Norton