I want a report which counts the number of Registrations per Class, where Registration relates to Registration_Class by ClassID.
Actually that works fine. However, I want to restrict the report to a specific year as in ClassYear (in Class) = 2008. I can't do it in a Find and I can't do it via script which I prefer: the following script has a global gFromDate and gThruDate in the Class table set to the date range I want, but doesn't work. I have tried the global field in Class, Registration, and in holdVariable a one record table linked to Registration and to Class. Go to Layout [ "RegistrationReport" (Registration) ] Show All Records Go to Record/Request/Page [ First ] Loop If [ Registration_Class::ClassYear < Registration_Class::gFromDate or Registration_Class::ClassYear > Registration_Class::gThruDate ] Omit Record End If Go to Record/Request/Page [ Next; Exit after last ] End Loop Sort Records [ Specified Sort Order: Registration::ProgramName; ascending Registration::FKClassID; ascending ] [ Restore; No dialog ] Enter Preview Mode Ron Carr
