SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I followed this article and it works fine if the number of items for a letter is less than 30.

But it fails when you have more than 30 items and go back and forth for a group. Say Under "S" you have 70 items (and it set to show 30 items per page), then when you click on next the grouping still fine. However, when you go back to 1-30 (the first page) all items starts with "A" shows up under "S". {may there is a bug in SharePoint 2010?}

share|improve this question
Does applying sorting to the title field help with the issue? – Panter Nov 8 '11 at 19:36
I tried that too but no. – Mary Rivers Nov 8 '11 at 19:48
How many items will there (eventually) be in the list? – Panter Nov 8 '11 at 20:05
In T I have 230 items, in P I have 23 items, they vary. the list will grow. – Mary Rivers Nov 8 '11 at 20:10
up vote 2 down vote accepted

It seems that it is a known issue, and a patch was released:

If you're looking for a workaround, instead of grouping you could use connected Web Parts and filtering.

share|improve this answer

Is the item limit for the view set to 30 to display as batches? I believe if the item display limit is increased to the maximum,the pagination within the groups will be removed and then everything should work fine.

EDIT: As I suggested in my comment, Subgrouping a different column would be a better option. You can first select a column which is more meaningful to group (For eg. Created By) and then subgroup them with Initials, or viceversa. It would look something similar to this post -

share|improve this answer
Actually, I am already using this method (as a temporary solution). Remember the DocLib is growing rapidly so eventually I need to set the limit. – Mary Rivers Nov 9 '11 at 18:42
How about trying a nested grouping for initials then? Create one more column called 'Sub Initial' with formula =UPPER(LEFT(Title,2)). Then Group by Initial and then Sub Initial. This will give you grouping of A to Z and within A you would have AA to AZ which reduces the possibility of paging also. I think this should be implemented in your case since the list is growing rapidly. – Deepu Nair Nov 9 '11 at 19:10
I don't know if user will like sub grouping but something to consider. I used =IF(ISNUMBER(VALUE(LEFT(Title,1))),"0",UPPER(LEFT(Title,1))) to accommodate numbers as well. – Mary Rivers Nov 9 '11 at 19:48
Anyone knows why LinkFilename is not listed for Calculated Column? – Mary Rivers Nov 9 '11 at 21:00
I don't think LinkFilename is a supported type for calculated columns. – Panter Nov 9 '11 at 21:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.