Re: X Y query

Article View: borland.public.interbase.sql

Article #802

Back to borland.public.interbase.sql Previous Next

#802

From: Quinn Wildman (CodeGear Develope...
Date: Wed, 09 May 2007 15:54

37 lines
1867 bytes

I don't quite understand what you want here, but I would guess a 
reporting tool would do what you want. The one most people use is 
Crystal Reports. I use Brio Reports.

adalberto baldini wrote:
> I have a procedure that joins two tables and  returns a pairs of columns 
> like :
> 
> col_1   col_2
> ------  ------
>  0        0
>  0        1
>  0        2
>  1        1
>  2        0
>  2        1
> .....
> 
> I would split col2 into n. columns to represent a matrix result :
> 
> a\b    0   1  2  3 ...
> 0      x   x  x
> 1          x
> 2      x   x
> ...
> 
> I don't know in advance num^ber of columns I could get.
> 
> could anyone suggest if exists any function that could do this or if I 
> need to work with a visual component in Delphi ?
> 
> Thans
> Adalberto BAldini

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;

Technical Details

Message-ID: <4641ee4f$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46418103$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,3a941881090ec663
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 09 May 2007 08:54:47 -0700
From: "Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: X Y query
References: <46418103$1@newsgroups.borland.com>
In-Reply-To: <46418103$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.143.19.108
Message-ID: <4641ee4f$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178725967 10.143.19.108 (9 May 2007 08:52:47 -0700)
Lines: 37
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message