Creating Custom Advanced Search Results

Hi, I am trying to do a couple of things that I know are possible with CB and Joomla but I am not exactly sure the best way of doing them so I thought I would ask here.

I have my members filling out several custom profile questions.

First, I want these profile questions and all other registration info to be part of an advanced search form. This advanced search form should be on its own Joomla page so non registered members can use the advanced search form. I want to be able to modify the advanced search form so some of the custom fields can be excluded or included. A big bonus is to have the ability to put any database field into the query that returns the results. And display this field on the web page.

Second, I want these advanced search results to be displayed in a table that I can customize to make it look nice. Based on the advanced search criteria there will be from 1 to 1000 results so pagination is needed.

Third, I need some calculations done per member and across all members (add across rows and down colums). These totals need to be dynamically generate based on the advanced query results. I will provide a basic example to illustrate:

Name	# of Red Cars	# of Blue Cars	# of Green Cars	Total # of Cars
Joe	2	3	1	6
Charles	4	5	2	11
Diana	1	2	3	6
Total	7	10	6	23

I have looked through many different modules and plugins and think I can put together a patchwork of things to get this to work but I want the easiest soultion. I don't mind paying for a professional third party extension. I have enough knowledge of php/mysql, css and HTML to modify as necessary but my skills are limited to do a big custom coding job. Any help will be appreciated. Thanks!

First, I want these profile questions and all other registration info to be part of an advanced search form. This advanced search form should be on its own Joomla page so non registered members can use the advanced search form. I want to be able to modify the advanced search form so some of the custom fields can be excluded or included. A big bonus is to have the ability to put any database field into the query that returns the results. And display this field on the web page.

Please see CB Userlists within your documentation, which you can download from the Advanced downloads section. It basically provides exactly what you're wanting.

Second, I want these advanced search results to be displayed in a table that I can customize to make it look nice. Based on the advanced search criteria there will be from 1 to 1000 results so pagination is needed.

CB Userlists have several CSS classes and ids for you to restyle and display however you want. It's already displayed in a table like layout.

Third, I need some calculations done per member and across all members (add across rows and down colums). These totals need to be dynamically generate based on the advanced query results. I will provide a basic example to illustrate:

CB Query Field does exactly this. It lets you query the database for whatever results you want and display them as a field. Please note this field is not searchable.