Re: Writing reports

Dirk Emmermacher wrote: > I've got a new job on my database. I try to make a report that do > following: > Adress-etiketten with to rows (That's no problem) > and various counts of one record (From one to n etiketten ) > I'm using INFORMIX 4.00. > Has somebody a solution for this problem?? > > Here is an example for the output: > > Mr. Mr. > Steve Miller Harry Smith > Broadway 3 Hollywoodroad 100 > 12345 New York 23456 Los Angeles > > Mr. Ms. > Harry Smith Barbara Miller > Hollywoodroad 100 Plaza 3 > 23456 Los Angeles 77777 Chicago There's an example of how to do that in my book "Using Informix-SQL" published by Addison-Wesley back in 1990 (for the 2nd Edition). It's in ACE, of course, but can be trivially adapted to I4GL or D4GL (or NewEra). And in the USA, the town comes before the state and zip code; the postal code precedes the town in (continental) European addresses. Britain has its own anarchic post code system which comes in about the same place as the US zip code. Also, US and British addresses have the house number before the street name. Isn't life fun? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>