I need to create a data view that joins and displays data from two lists, and to sort and group on all of the fields displayed, not just fields from the main list.
I created linked datasource from two of my lists, joined them on a common field, and firstÃÂ inserted fields from the main list.ÃÂ Then I insertedÃÂ fields from the other list as a Joined Subview,ÃÂ which worked just fine, but now I need to be able to sort and filter on fields in that joined list, for which there doesn't seem to be an option.
Does anybody know whether it's possible and/or any workarounds/solutions for this? Basically, Is there a way to create a joined view of two lists where all fields are displayed inÃÂ separate columns, and not in a table within a cell as in a case with joined subview?
Any comments are highly appreciated.
View Complete Post