Count of items in a list
Hi all,
Is there a way to see how many items are in a list? I know I can scroll thru the pages and see the item count of the page i am on, but I have list that has about 5000 items and I need an exact count.
TIA,
Joe
July 21st, 2010 4:51pm
Find a field in that list that can only have unique values.
Create a View where you specify (in Totals) Count for that field.
The Count of the number of items is at the top left of that view *on the first page*. See here if you want to see it in real life (I used the URL field because each URL in that list is different or at least ought to be
Test of Count
2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
2007 Books:
WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2010 6:58pm
Yes there is. You can edit the view.
Access the view that you want to add the count too, then access the 'Modify this View' from the views drop down.
Scroll down to the Totals section, expand it and select which columns you'd like an item count to appear under.
This change will appear at the bottom of your refreshed list.http://www.final-exodus.net
July 21st, 2010 7:02pm
> will appear at the bottom of your refreshed list.
In my test I was surprised to see that the Count was at the top of the list on the first page.
Having it near the bottom wouldn't be that much help as you would have to scroll through the pages and if you do that you already see how many items there are even without the Count.
2010 Books:
SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
2007 Books:
WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2010 7:05pm
If you can customize the page, there is a parameter $dvt_RowCount that contains the count of the rows and you can output this near the bottom so it will say [1-25 of 180] etc.
Although I believe you must have XSLT Filtering turned on for the value to get passed in properly.
Kevin
July 21st, 2010 8:53pm


