Large Scale Reporting

[chrisonmaui]

Hi,

I'm struggling a bit with the reporting capabilities of filemaker.

Here's what I want to do:

we have 10 files each for a different kind of test report.

each report has the name of the person who took the report in a field and the site of the report.

I want to get a summaries for date ranges for all report kinds.

So I want a report containing

Start Date: 01-01-02

End Date: 01-01-03

Test: one

Site Reporter | A | B | C |

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

Site A | 10 | 4 | 2 |

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

Site B | 1 | 2 | 4 |

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

Site C | 0 | 10 | 1 |

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

Test: two

Site Reporter | A | B | C |

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

Site A | 10 | 4 | 2 |

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

Site B | 1 | 2 | 4 |

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

Site C | 0 | 10 | 1 |

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

and so on for the ten different test types.

Using SQL i would do it like this:

Select count(testID) from testone.fp5 where TestDate > startDate AND TestDate < enddate AND Reporter=A;

so how to do it in FM?

hope this is clear.

C.s.