On 25 Jun 2002 at 19:43, PODESTA Mariano APRE wrote:

>how can i get this if the count of cities may change:

Good news: it is possible. Bad news: not by IB stuffs but on the
client side only. People here use any kind of Decision Cube for this
purpose. All _good_ report engines have cross-tables (or something
similar). If your report builder doesn't have it, drop him and look
at Fast Report (www.fastreport.com but I'm not sure about .com). They
say Crystal Report also is a good one.

SY, Dimitry Sibiryakov.