Solved

Filter Data Form web part from a drop down menu

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint 2013 - Bulk Add Users 6 77
Sharepoint 2013 Library List View Limitations 9 56
SharePoint integration. 1 55
Populating html form in Sharepoint using JSOM 11 63
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
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 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…

772 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