Search - Find Multiple - drop down list

[Leb i Sol]

Hello People!

I was hopeing one of you outhere has found an easy solution to this relatively common question.

When user performs serach - find for one Location (of total 5 possible) results return just perfect:

Location | Total

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

LA | $120

These results are retuned when user slecets onyl one of 5 possible locationos from the value/drop down list.

I was wondering, IF it is possible, how to have an option for "All Locations" on Search page so the Results return as

Location | Total

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

LA | 120

NY | 300

DC | 500

LV | 550

CC | 300

Please Help!

Thank you guys!

[Garry Claridge]

Try assigning a "" value to the location field. This should return all values.

Good Luck.

Garry

[Leb i Sol]

Garry Garry Garry! = Thank you Thank you Thank you

I owe you a dinner right after I slap myslef for not thinking!

Grateful as always!

[Korky]

The easiest way to achieve this is by creating a summary report. First create a new summary field "Locsum" (or whatever).Define this as a count of your "Location" field when sorted by "Location".

Now create a new blank layout "Locations"; delete the body part and add a sub-summary part. Into the latter drag the "Locations" field and the new field "Locsum".

*Change into preview mode, make sure you are in "Show All Records" and sort the records by "Location". Your report will read like

LA 120

NY 300

etc

Each time you want to view the report just repeat from * above.

[Korky]

Sorry,misunderstood the question!

[Leb i Sol]

Garry!

Using "" as a value does return all Locations BUT BUT the Totals associated with location and returend are TOOTALS OF ALL locations together...so instead of :

Location|Total

LA | 120

NY | 300

DC | 500

LV | 550

CC | 300

I get:

Location|Total

LA | 1770

NY | 1770

DC | 1770

LV | 1770

CC | 1770

sooooooooo?:

p.s. you might have answered this in some other posts......