Solved

Filter Data Form web part from a drop down menu

Posted on 2011-03-03
5
1,059 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now