difficult query

[Peter De Keer]

I hava a 'table' called jobs, witch has the following fields:
* date/time
* function
* person --> link to other objects
* remark

I want to do some reporting on that one 'table' (I know you guys don't
like to hear the word ;-)

functionname1
functionname2 functionname3 functionname4
date1 jobs open / jobs taken jobs open / jobs taken jobs
open / jobs taken jobs open / jobs taken
date2 jobs open / jobs taken jobs open / jobs taken jobs
open / jobs taken jobs open / jobs taken
date3 jobs open / jobs taken jobs open / jobs taken jobs
open / jobs taken jobs open / jobs taken
...etc

So this table is fully dynamic!
If one function is added, the whole table gets a new column.
If one date is added the table gets an new row.
If a job is assigned to a person, the "jobs open/jobs taken" count
should change...

Is this a job for Map/Reduce?
How do I aggregate all those 'count' values?

Thanks for your input!


P.S.: AppJet is closing it's application hosting on Juli 1st.