Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Filter Data Form web part from a drop down menu

Posted on 2011-03-03
5
Medium Priority
?
1,088 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…

564 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