DA Search Wizard scope?

Hi there, I need to create a quick data reporting page on my site. Has anyone any examples of what the DA Search Wizard can achieve, I didn't want to spend days testing to see if it can do what I needed?

My requirements are quite simple I think? I have a query with 6 columns displayed in a dynamic table. In the header of each column I would like to have a drop down containing the data in each column, I could then filter by columns 1, 3 & 6 for example?

If that is not possible would the search wizard allow me to create a search form with drop down fields for all 6 columns, submitting this would return a results page filtered?

Is this possible with DA search wizard?

Many thanks

"In the header of each column I would like to have a drop down containing the data in each column,"

I'm not quite sure i understand the use of the menu in this description.

But for the second option, Yes, the search filtering would be possible, it would require creating separate recordset to feed each drop down menu.

Hi Jason, for the second option I have 1 query that contains all the columns I want to search on eg; CaseID | Advisor | Month | Status | Source | Commission

Could I not point the wizard at each of these fields within 1 recordset or would I need to duplicate the same recordset 5 times?

In my testing I have done this;
1 - create new php page, create the recordset with all fields required and insert into dynamic table.
2 - Run the wizard choosing this recordset & mysql, opt to create new search form.
3 - When I am prompted to select fields to add to search it seems to have pulled through all fields from every table rather than the basic 6 from my recordset.
4 - I push on and choos finish, this creates a new search form.
5 - Running this gives me a select field as chosen but with no data in, when I look at code its just a basic form with a simple select, no other code?

Am I missing something, do I need to create the search form manually and add all search code to it?

Thanks

"1 recordset or would I need to duplicate the same recordset 5 times?":

you only need to use one recordset.

"When I am prompted to select fields to add to search it seems to have pulled through all fields from every table rather than the basic 6 from my recordset."

The search wizard will allow you to search on all the columns in your table, not just the ones that are returned by the recordset.

"Running this gives me a select field as chosen but with no data in, when I look at code its just a basic form with a simple select, no other code?"

You need to populate the select list with the values to search.

This can be done using a recordset or by populating the list manually

Hi Jason,
sorry for delay have been working on other things and not much time to try this out. My problem is I have created a crosstab style mysql query with custom columns which do not exist in my tables.

For example my crosstab query takes a date column, formats it to 'MONTHNAME' then displays it across the table left to tight as columns. I then want to run a search lets say from Jan to Mar, because I cant use the recordset in search wizard I don't know where to point the select inputs?

Advisor | Jan | Feb | Mar | Apr | May
Gary 10 6 78 89 43

From table above the search would return only columns Advisor | Jan | Feb | Mar

Will the DA wizard not allow this, I imagine its quite a common search parameter? I have attached the 2 created pages if it helps?

Thanls

The Data Assist Search wizard works only with the columns in your data base, not with the aliases you create in your table, The Search Wizard will not work with your cross tab query