Reporting on Value Lists across multiple Y/N field

[RBSolutions]

Okay.....

Once again, I'm sure I'm missing something fairly obvious but, I suspect, I'm standing "too close to the trees".

Here's the background info ----

Database Type -> Seminar Reservation/Attendance

Field Info (Fields to be reported on/considered);

Household Position (HshldPoz) - Text (by Value List)

Value List -

[*]Head of Household

[*]Spouse

[*]Youth

[*]Child

[*]Speaker

[*]Other

Day of Attendance (DayStay1 - DayStay8) - Check Box (Y/N)

Other data;

- DayStay(x) will be corrolated to a date in the finished product.

- HshldPoz must be a value list since each type is used to calculate seminar cost.

Assumptions;

For HshldPoz value list, all types except Child & Youth are considered Adult attendees.

THE PROBLEM *groan*

I need to publish a report that will show how many Adults/Child/Youth will be attending each day with a Summary field for each column (see example below. Pardon the periods, UBB Code doesn't do tabs and spaces very well.)

.........DayStay1........DayStay2.......DayStay3..(etc)

Adult........4(AdltSt1).....2(AdltSt2).....1(AdltSt3)

Youth.......2...................1..................4

Child........1...................4...................2

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

Totals.......7..................7...................7

Now the totals won't be a problem since it's a simple summary field but I'm having a real problem getting the other data elements (AdltSt1, YthSt1, etc) to calculate. I've tried Count(field) and Sum(field) without much success. Any assistance will sure be appreciated.

Dan

[Ugo DI LUCA]

There are several ways to create such a report, but you didn't tell us how the date1, date2, date3 were populated.

Are these date1 current field names ?

Are the globals populated by a script based on the seminar dates ?

Do you want to have a sub-list of names in a body part, or do you just want the counts to appear ?

For a Total Summary, you could use a concanation "Category&Date" and a script (looping through each categories and each range) could set each value from the result of count(selfJoinonConcanation::field).

Depending on the number (range) of dates you need to make appear, you could also have a set of say 7 dates, and if needed script a Day+ or Day- to have these fields populated.

Just some ideas...

You'd need :

g_DatefieldCounter

g_date1, g_date2,....

g_valuechosen

cg_concanation = g_DatefieldCounter&"-"&g_valuechosen

The script sets in a loop each date and

One solution I'd consider would be to script any entry using relationships.

For example, set all dates to be a global and use a g_category field.

If any date is a global, use a concanation g_date1&Category