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:
Issue:-
Unable to view complete Reports. Row count limited to 2035
Cause:-
1> ASP buffer Limit was set to false
2> Buffer limit was using default settings.
Resolution:-
1> Enable the Buffer Limit to true.
2>. On all computers on which a reporting point is
enabled, run Regedt32 or
Regedit.
3. Navigate to the following registry key:
\HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting
or on a
64 bit Operating System:
\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Reporting
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.
No comments:
Post a Comment
Let me know if this helped.
I'd really appreciate any comments (well, only nice ones) so please feel free to let me know what you think of the blog and also ask for further help...