0

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!

1 Answer 1

0

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.

2
  • 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? Jul 30, 2013 at 22:53
  • You're in control of the XSL. Just change it.
    – teylyn
    Jul 31, 2013 at 20:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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