Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I currently have a column which is a multi-choice lookup list, I'd like to create a row for each multi-choice items per row and group by the multi-choice column.

I've tried using XSLT to format the multi-choice strings (separated by ;#') using spxslt however I still cannot figure out the code for grouping.

An example of what I'm after

Application Lookup List

MSWord

MSExcel

Document Library

DocNumber1 | MSWord; MSExcel

DVWP

MSWord
        DocNumber1

MSExcel
        DocNumber1

Any assistance would be greatly appreciated.

Thanks!

share|improve this question
add comment

1 Answer

This article on EndUserSharePoint explains how:

https://www.nothingbutsharepoint.com/sites/eusp/pages/sharepoint-group-by-a-column-with-multiple-values.aspx

You basically need to create a linked data source to the lookup list and the main list with the join option.

share|improve this answer
    
Thanks, is it possible to hide the look-up list headers when the row count is 0, rather than displaying the header and dvt_2.empty? –  user1142132 Jul 30 '13 at 22:53
    
You're in control of the XSL. Just change it. –  teylyn Jul 31 '13 at 20:48
add comment

Your Answer

 
discard

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.