I am attempting to create a series of web part connections featuring Data View Web Parts (DVWP's) based on cross-list data sources. The cross-list DVWP's display fine before making the web part connections, but fail to display the correct data once the web part connections have been established.
Overview:
- Web Part A: Project Portfolio List (Custom List)
- Web Part B: Staffing Model List (Custom List - Cross-Site Data Source)
I would like to use the ProjectID field in Web Part A to filter the items in Web Part B. The creation of the Web Part Connection all goes smoothly and I'm able to associated ProjectID in A with ProjectID in B. The only problem is that the filter returns null data on the live web page. A closer examination of the filter settings for Web Part B reveal that the only filter setting that appears to be active is the 'Content Type' filter used to isolate all of pertinent lists (i.e. cross list data sources) in my site tree. In this light, I would assume that 'all' entries would be returned not zero. The end goal is to return only those entries in Web Part B that have the same ProjectID as the active row in Web Part A. Any suggestions as to what settings I should investigate or any alternative approaches that I should consider?
