.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Filter and Sort on fields in a joined dataview in SharePoint Designer

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

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

More Related Resource Links

How to tie a dropdown list from a nother table to a dataview in sharepoint designer



i created a dataview for a user table to insert new records. now i have to use a dropdown list that get data from another table. to insert in my user table. in the user table only the code is stored. but i need to get that code description that is in another table in my dropdownlist to choose from in my dataview.

how can i do this in sharepiont designer2007?

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Error by insert new item in dataview sharepoint designer



doesn't any1 know the answer of my question?

i'm trying to create a data view with the edit, delete and insert function.

the edit and delete works fine. only the insert gives me this error:

The data source control failed to execute the insert command.

plz help?

Conditional formatting on a joined subview using SharePoint Designer 2007 does not work

I have 2 SharePoint lists, one is a parent task list and the other a child task lists.  In SharePoint Designer 2007 I have created a combined datasource from these 2 lists.  From there I created a new ASPX page inserting the parent list as a dataview and the child as a subview.  So far so good, all is functioning as you would expect.    Now I need to apply conditional formatting to cells and rows in both the parent and child lists.  I can create a very simple condition on a row or cell of the parent list such as "If ID Equals '2988' format the background color as green" but no conditional formatting appears for the row where ID = 2988.  Incidentally, if I change the condition to "not equals 2988" the background changes to green. The line in the code view of Designer appears as follows:  <xsl:if test="../../../Rows/Row/@ID = '2988'">background-color: #00FF00;</xsl:if> I've seen this question asked here and in blogs but never answered.  If anyone has a solution, I would love to know what it is. Thanks; Dave  UPDATE:  it doesn't seem to matter if you add the additional fields as a joined subview or not.  If I add 2 data views, both using the linked data source which is configured to JOIN the contents of the data sources the conditional formatt

Update Infopath Fields with SharePoint Designer Workflow


Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.




Update Infopath Fields with SharePoint Designer Workflow


Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.

Unable to write to SQL using a DataView in SharePoint Designer


I am connecting to a SQL database using SSO and surfacing data in a DataView web part. However, when i try to write back to the database using the DataView web part, i'm getting an authentication error.


Here is what I'm doing:


  1. In SharePoint Designer I create a datasource that connects to a SQL database using Single Sign-On. The SSO account successfully connects as the correct user to the database SQL and retrieves the data, which i can view in the data source details.
  2. I create a DataView Web Part that uses the data source, and all goes fine-- the the DataView displays the data, and i can view it in a web browser.
  3. In the DataView web part's properties, I check the synchronize commands checkbox and enable the add/edit/delete controls for the DataView. The edit, insert, and delete controls appear in the web part.


Upon trying to insert data using the browser, i get the following error:


The data source control failed to execute the insert command..


i get a similar error for editing and deleting entries.


When looking at my

Sharepoint designer 2007 - Java date query - and how to disable value required for hidden fields


Hi guys,

created a list, i've managed to get field to hide and dates to populate into the applicable fields, I just have 2 queries taht I need some help with

>I need to work out how to get var tmoz to ignore saturdays and sundays - i.e. if request is raised on fri - it would default to the following mondays

>I need to work out how to mark a field as no input required if it is hidden, and input required if visible (urgent change justifacation)

 Below is the current java i'm using

<script type="text/javascript">
  function hideFieldsOnStart()
   //hide the control at start
   var control = getTagFromIdentifierAndTitle("input","TextField","Urgent Change Justifacation");
   var control2 = getTagFromIdentifierAndTitle("input","DateTimeFieldDate","Proposed Implementation Date");
   //add an onchange event to the dropdown
   getTagFromIdentifierAndTitle("select","DropDownChoice","Change Type").onchange = function() {ChangeEvent()};

Sharepoint 2007 list troubles: IP fields and sort by IP


Help! I've created text fields that have IP's but they do not get sorted right.


I know this is correct sort for normal text. Do anybody have any clue of how I can use IP's in Sharepoint 2007 lists?

Set value for the Task Form Fields in SharePoint Designer



In our requirement we are customizing the approval workflow in SHarePoint designer 2010

I have created a new Task Form Field and i need to set a value for this field (for each task) in the SharePoint Designer.

Is there any possiblity to achieve this requirement?




Populate fields from custom list..... Using Sharepoint Designer only



I have a custom list with all Active Directory user data in it......

(AD name / Email / Address / tel .... etc)


I then have a form that user can select their AD name, i want to populate the fields "Phone" + "Email"   etc....

from the custom list....


How do i do it ? using sharepoint designer only ??


Thanks Rob

Sharepoint Designer 2010 - Generated fields names causing errors


I'm creating a number of edit forms for external lists in Sharepoint Designer.  We're using Foundation so these are just the standard forms, not Infopath forms.

Basically I've cretaed the external lists and forms and have been deploying these using a Visual Studio solution.  In the forms I have replaced all the generated sharepoint form controls with asp text boxes or Drop Down Lists and have given these meaningful IDs so it's easier when hooking them up to asp validators.  This worked for the first deploy but now when i edit the form (for example to change a text box to a Drop Down List) I get errors which seem to relate to the field names generated by Sharepoint Designer.  It has generated databind statements which try to bind fields ids already in use elsewhere on the form.

The error message is

Error while executing web part: System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'DataBind'. See InnerException for a complete description of the error. ---> System.ArgumentException: Item has already been added. Key in dictionary: 'ff15_1' Key being added: 'ff15_1'

Can anyone explain why it's generating these duplicate references?

How to aggregate with a joined subview in Sharepoint Designer



I have a data view web part which uses a "Linked Sources" as Datasource. I have created a master table, then created the joined subview inside the data view web part as usual. Instead of showing the detail data in the subview, I just showed the number of rows as this is what I am interested in.

The master table is grouped by a specific column, so here is a representation of what I have:

 FIELD_X   FIELD_Z   NUMBER(count of rows in the subview)
FOOTER_A (count of rows in the master table)

 FIELD_X etc...

the count of rows in the subview is given by the following:

Now, in the footer I want to show the total count of rows of the subview , not the count of rows of the master table. How can I get the count of rows of the subview based on the grouping of the master table?

More specifically the problem is that the subview cannot be directly link to the group header; it can be joined to a field in the master table which must then be filtered based on the group header.


SharePoint Designer - custom forms - DateTime fields


Whenever I create a new custom display form using SharePoint Designer the DateTime fields display value using wrong format and the time is not correct.

For example:
Default display form: 29/03/2011 11:39
Custom display form: 2011-03-29T10:39:17Z
(not only different format, but also different time)

Why is that and how can I display correct date and time using the correct format?

SharePoint Designer

This video series shows you how to quickly and easily build complex business solutions on the SharePoint platform. Microsoft Office SharePoint Designer 2007 Business Administrator Training is a one-and-a-half hour, 300-400 level training series, produced in collaboration with the SharePoint Product Team and Total Training

Trying to send email using Sharepoint Designer 2007 workflow and email enabled list


I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,


How can I implement this workflow scenario with SharePoint Designer?



I have a document content type and a library which contains this content type. here is what I want to do:

- when user creates a new document in this library, he will enter some user  names with people picker and then a message including some columns of the content type will be sent to that users. And then, at a certain date (lets say 1 day before a date that is one of the site columns) another email, a reminder will be sent.

I havent been able to find :

1- how can I replace a people picker field on workflow initiation form and how can I make it sent email to the user.

2- How can I make it sent a reminder email 1 day before the date that is stored in one of the columns of the content type(current item)

any help would be welcome,


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend