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?