Sharepoint Custom Search

I'm using Sharepoint, MOSS 2007 and Sharepoint Designer.

I've created a site that has a few custom forms (lists) used for collecting data from the users.  Is there a way to create a custom search page for the user to query the data that was entered.  I know that you can create custom views to organize, filter and order the data into the columns you want.  But the client wants a custom search page that allows them to pick specific criteria to search from to populate these views.  So on their search page, they'd have the drop downs to pick data from that was used on the form (list) page.  I'll attach a screen shot of a search page that I create on their current web page, but now we're migrating them to SharePoint and we're trying to emulate what they have now the best we can in SharePoint.  A push in the right direction and/or an article would be great!

Thanks! example of current search
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.

Based on your requirements i believe that you need to create a custom form similar to the one shared in the screenshot. I need few inputs from your end:
1. Are you going to search on one list or multiple lists?
2. If from one list, then you need to create dynamic CAML query to return results. You can do this with the help of CAML query builder and then adding the conditions dynamically to it and generate the query.

If you need help with dynamic CAML just let me know.

geoffswebAuthor Commented:
Yes, I'll only search from one list.  I have never heard of CAML.  I'll Google it now :)
geoffswebAuthor Commented:
So you have to create this page using custom code( CAML)? Sharepoint doesn't allow you to create a Search page where it allows you to select what form/list to use to create the search?
You could create a Search Scope to only return results from a particular list/library.  In conjunction with scopes, you could modify the search webpart and edit the XSLT to shape the results to your display requirements.

Info on creating Scopes:

Info on XSLT custom search results page:

Hi Geo,

Based on the UI you shared, i feel your form is similar to the once created with the help of Reporting services. You can create a user control using sharepoint object model and then deploy it using smart part. You need to add all the filters as controls on it, and generate a dynamic query with appending all the filter(if changed). Pass that query to return the list items.

Or if your filter parameters are static, you can create a custom form with html controls with static values. Add a search button which will pass the filter conditions in query string(add all the parameters irrespective of change in value)  Use the dataview webpart to retrieve list data and configure it to be filtered based on the query string parameters and there values.
NOTE: keep in mind that you will be able to pass maximum of 255 in query string(just check).

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
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.