Sharepoint 2010 filtering options

I am using Sharepoint 2010 and I am pretty new to using this softwares.  I have sharepoint designer downloaded and like this quite a bit.  However, I am also using the web based systems too.  Anyway, I have imported an excel file into a list.  My list is called AtlasPDF_2011_Listing.  In this list I have a few columns.  

ID1, Region, Market and PDF_Link

The PDF_Link is a hyperlink field that I manually created inside the list and copied my http path to.  All is good

Now I want to create a way for my users to be able to select a region, then select a market and then use my pdf link to get to my pdf.

So what is the best way to do this and since I am giving out 500 points please lead me to some sort of walkthrough.  I'm hoping for a few different options.  To figure out what is the best way to do this.

Thanks for your help in advance.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Here is one of the solution:
Create a view in include those three fields "Region", "Market" and "PDF_Link".

Create a new page and add the list as webpart and in tools pane select the create view.

In this way you have a page with that list with only three columns visible.
Now, use can hover the mouse to the column title and filter the "Region" and "Market" one by and one and finally will have filtered rows and then can click on "Pdf_Link" column to view the pdf file.


1. Create a view with grouping by Region and Market. Then people can simply select (or filter) the region and only see the pdf links for the interested markets.
2. If using the SharePoint server(not foundation)  Try looking at the list filters webpoarts and list connections. You can create 3 webparts, one for region, 2nd for region and market and 3rd for market and links. Then connect the webparts so that filtering one will trim the results in another. No coding or designer involved.
3. Look at options like which have filtering capabilities similar to your needs.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
flfmmqpAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.