Re: Writing reports

Jonathan Leffler wrote: > > 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> You can write the text into fixed places in strings: LET longstring[i,i+50] = part_of_address Increment i on each report loop and print when needed. Don't forget the last addresses. Don't Russian addresses come upside down: town first, then street and finally name? Boshe moi! -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---