Solved

Filter Data Form web part from a drop down menu

Posted on 2011-03-03
5
1,068 Views
Last Modified: 2012-05-11
Hi, I have two data form web parts on my page in Share Point Designer 2010.

The first one pulls in a single column from a list called 'User name' (people or group field)

I then have another data form web part that pulls in several columns from a traning course list about courses (ie: course description/couse Name, course cost, and Attendees (person or group field)
What I need is that when the user name is selected from a drop down menu (in the Students web part), all the courses (in the courses web part) that have that user name in the attendees field, show.

So I changed the first data form web part that filters the user name to a drop down design, so the user can select a single name from the drop down menu. I then connected this web part (called students) to the other web part (called courses), using "send row of data to" then set the column in the source web part (user name) in the same row 'Attendees in the 'Courses' web part. Now it works if the source web part (Students) doesn't have a Drop down design) I think it's because it want to create a hyper link when joining the web parts, and drop down design doesn't have a hyper link, it's an option. So my question is, how can I filter the data form web part from another data form web part that is of drop down type.
0
Comment
Question by:DJSharepoint
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:EagleUK
ID: 35043202
Are you using a Choice Filter Web Part for the Students list? If so, select Send Filter values to... instead of Send row of data to...

Unfortunately, I can't test this as my ISP doesn't provide access to the full range of Web Parts and I don't have access to a 2010 test server at the moment.

Hope this helps.

0
 

Author Comment

by:DJSharepoint
ID: 35141095
Hi EagleUK, sorry for late reply, been busy on a project. No both web parts are Data Form web parts that are pulling in the data from a rest connection. The reason for this is because the two lists are on another site collection/ Although I would like to now more about the Choice filter web part. Is this a single item drop down?

Can you let me know how you use the choice filter, so I can hook it up to the Attendees column in the User Name list, and connect it to another web part so that the second web part shows all items that have the same attendee in it that was selected in the choice filter list/web part
0
 

Accepted Solution

by:
DJSharepoint earned 0 total points
ID: 35193180
Hi all, found the solution here. Apparently you need to add some code so when you select another value in the drop down style of the dataview web part it will refresh the page and show the new filtered value. Instructions here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;838685 

Works in 2010 as well!
0
 
LVL 7

Expert Comment

by:EagleUK
ID: 35193270
I'm glad that you found the solution; sorry I couldn't have been more help. I'm amazed that the 2003 code works all the way through the 2010 version!

Good luck

EagleUK
0
 

Author Closing Comment

by:DJSharepoint
ID: 35225432
Found the solution myself
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question