SMS 2003 Report Value 1000 Row Limit

[wmmayms]

If you create a report with a prompt you sometimes get more then 1000 results, which means you won´t be able to select all of them since SMS has a limit of 1000 rows.

 

Example (when you click the values button it might look something like this):

 

Here is how to change so you will see all records in the "values" list:

1. Log onto the primary SMS site server or the server that is your reporting server.

2. Go to C:\Inetpub\wwwroot\SMSReporting and take a backup of your file called FilterSample.asp

3. Go to C:\Inetpub\wwwroot\SMSReporting and edit the file FilterSample.asp with Notepad.

 

4. Search for the below lines (marked in red):

'this is the number of 'Values'

intRecordCount = .GetRecordCount()

intMaxValuesRecordCount = .GetMaxValuesRowcount()

 

Replace with:

'this is the number of 'Values'

intRecordCount = .GetRecordCount()

'intMaxValuesRecordCount = .GetMaxValuesRowcount()

 

5. Search for the below lines (marked in red):

Set FieldNames = .FieldNames

flgEmpty = 0

ReportRows = .GetRows(.GetMaxValuesRowcount())'to limit Values... list

intColumnsCount = UBound(ReportRows, 1)

intRowsCount = UBound(ReportRows, 2)

 

Replace with:

Set FieldNames = .FieldNames

flgEmpty = 0

ReportRows = .GetRows '(.GetMaxValuesRowcount())'to limit Values... list

intColumnsCount = UBound(ReportRows, 1)

intRowsCount = UBound(ReportRows, 2)

 

6. Save and exit.

 

If you update your report it should now look like this instead:

 

Cheers!

 

Here is Technets version of the same thing

Edited November 29, 2009 by anyweb
added Technet Link