Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Filter Data Form web part from a drop down menu

Posted on 2011-03-03
5
Medium Priority
?
1,082 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Viewers will learn the different options available in the Backstage view in Excel 2013.
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…

604 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