Wednesday, November 09, 2011

SharePoint Designer 2010 Data View bug in Join Linked Data Source!

I have 2 Data Sources - Category and Product, I created a Linked Data Source to join these 2 tables using their common key, and created a Data View to access this Linked Data Source, unfortunately the Data View display only the blank data view but with the number of records correct which I can see it from the paging info.


Finally I found out there is a XSLT bug in SharePoint Designer 2010 after spending sometime to troubleshoot this funny problem:-


The node is selecting the wrong data source value, we can erase the data source value inside this node and use XPath Expression Builder to find out the actual data source value.


After correcting the data source value by using XSLT Expression Builder, my data view work like charm!

1 comment:

botanden said...

Nice post, but don't you think that categories must not be repeated for every item? I guess that's the point of these linked data sources. Otherwise it would be possible just to write joining SQL statement when configuring normal data source.

M$ people broke the whole idea of linked data source. Brilliant.