Find - Results ...Multiple repeated results?!

[Leb i Sol]

Hello Gurus!

I need your help again...Here is my situation:

-On a Search.htnl I have raio buttons set to 4 Locations. When one is selected I get these results just fine:

Location | QTYTotal | AmountTotal|

-----------------------------------

CA | 3| $60.00|

My goal is to have an additional 5th radio button that will hold the value "All Locations" so when checked I would get the follwoing (all) results:

Location | QTYTotal | AmountTotal|

-----------------------------------

CA | 3| $60.00|

NY |4 | $80.00|

MD | 7 | $140.00|

So my question is how/what value to assing the button "All Locations" to compleate the search as mentioned? All three fields are in the same DB!These QTYTotal and AmountTotal are summary fields but if I select an empty value for All Locations it return Totals for ALL Locations together not each one separatly.....what to do...is this a DB design flaw?

Thank you guys!

[Addam]

I know how this can be done using a hidden field and JavaScript... How familiar are you with JavaScript?

[Leb i Sol]

somewhat.... I can go throught it and get the concept but writing it myslef is a bit of a problem...unless we talk about rolloevers LOL

so what would be the code?

thanx

[Leb i Sol]

so Addam......

how about sharing that knowledge?

[Unable]

Looks like something which can be handled with simple CDML. Display 3 fields from found records set.

[FMP-Record][FMP-Field:Location][FMP-Field:QTYtotal][FMP-Field:TotAmt][/FMP-Record]

set in a table.

There is probably at least one example of this in the SampleFiles forum.

[Leb i Sol]

that IS what I am using but that returns:

Date|Location | QTYTotal | AmountTotal|

-----------------------------------

1/1/02 |CA | 3| $60.00|

2/2/03 | CA| 6| $120.oo|

when one Location is selected on a search page.

What I need is "All Locations" selected. Location is a field that has 5-6 possible locations entered. If none (all)selected I get:

CA....

NY...

MD...

CC...

MD...

WY...

WY....

I gues what I am sking is how to NOT display the duplicates?

[Unable]

I gues what I am sking is how to NOT display the duplicates?

that IS what I am using but that returns:

Date|Location | QTYTotal | AmountTotal|

-----------------------------------

1/1/02 |CA | 3| $60.00|

2/2/03 | CA| 6| $120.oo|

I'm sorry, what are the duplicates? You have records for two very distinct months and years.

This probably has something to do with your search parameters.

[Leb i Sol]

ok my mistake.....

when a user types a date range or a single date and searches lets say for : date:1/1/02 AND location "LA" (multiple records are made on this location on this date) I would get this:

date|Location|TransactionAmount

--------------------

1/1/02| LA | $120

1/1/02| LA | $50

1/1/02| LA | $170

----------------------

TOTAL: $340

all this works great when only ONE location is entered/selected; If I select "ALL Locations" the list returns with ALL locations and total of ALL of them not the each location individually (hm...now that I said it..it might be the DB..anyhow)

what I would like to see:

date|Location|TOTALtransactions

--------------------

1/1/02| NY| $56000

1/1/02| CA| $5000

1/1/02| WE| $17000

----------------------

[Leb i Sol]

this post has been answered on cross post:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB12&Number=60382&fpart=1&PHPSESSID=