1

On a SharePoint 2007 environment I have a Data View Web Part that merges the contents of 2 document libraries. The "Enable sorting and filtering on column headers" is set to yes. However when I go to use the filter in the column header it only shows items from 1 of the data sources.

Source A Column
1
2
4

Source B Column
3
5 

DVWP Column
1
2
3
4
5

DVWP Column Filter Choices
1
2
4

How can I get the filter to show data from both sources?

Improve this question
3
  • I've had a lot of trouble with that setting myself. Can you do it in a Content Query Web Part, instead? I've found that much easier to set up for combining lists if it's default settings work for you.
    – Tom Resing
    Commented Jul 13, 2011 at 15:09
  • From what I can understand the Content Web Part will only display items filtered down from a top level source. Unfortunately it does not look as though this can be done because with the 2 form libraries that I am trying to merge do not have any common ground on which a filter can be made (such as a content type).
    – Rkaede
    Commented Jul 15, 2011 at 8:18
  • Are your libraries on the the same site collection? If so, they share at least one common ancestor and you can use the fields from the Document Library content type for filters in the web part properties. DVWP may work for you, but this may be an alternative. There's a lot on the web about the CQWP, here's one starter article: blog.pathtosharepoint.com/2009/06/08/the-content-query-web-part
    – Tom Resing
    Commented Jul 15, 2011 at 22:55

2 Answers 2

Reset to default
1

Another approach is syncing external content with native SharePoint list instead of viewing in web parts only. Going this way you have all options of native SharePoint lists available, including view options to group and sort, but also search and change workflows.

More Information: http://www.layer2.de/en/products/Pages/Cloud-Connector-for-SharePoint-2010-Office365.aspx

Improve this answer
0

I have sometimes seen columns not show up depending on how they were created within the list/library. I have a workaround for this issue: If you create the missing column as a site column, then add it to the list/library, it will show up in the filter choices.

Improve this answer
1
  • Unfortunately the columns are already site columns. This is due to them being promoted fields from an InfoPath form.
    – Rkaede
    Commented Jul 15, 2011 at 9:24

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.