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?