Re: Making a QR report ...

Article View: borland.public.cppbuilder.database.ado

Article #847

Back to borland.public.cppbuilder.database.ado Previous Next

#847

From: Vladimir Stefanovic
Date: Sun, 19 Jun 2005 15:32

61 lines
2231 bytes

Some changes to the problem:

Hi ,

The bad news is that my problem become more complicated,
but maybe easier to solve because now I have two sources available
(if needed). Here it is:

TABLE:
--------------
F1   F2   F3
--------------
AAAA BBBB CCCC
DDDD EEEE FFFF
GGGG HHHH IIII

Note:
F1+F2+F3 == "PRIMARY KEY" IN THE TABLE (NO DUPLICATES)


QUERY:
--------------------------------------
ID  xxxx xxxx F1   F2   F3   xxxx xxxx
--------------------------------------
ID1 xxxx xxxx AAAA BBBB CCCC xxxx xxxx
ID2 xxxx xxxx AAAA BBBB CCCC xxxx xxxx
ID3 xxxx xxxx AAAA BBBB CCCC xxxx xxxx
ID4 xxxx xxxx GGGG HHHH IIII xxxx xxxx
ID5 xxxx xxxx DDDD EEEE FFFF xxxx xxxx
ID6 xxxx xxxx DDDD EEEE FFFF xxxx xxxx
ID7 xxxx xxxx GGGG HHHH IIII xxxx xxxx
ID8 xxxx xxxx AAAA BBBB CCCC xxxx xxxx


Now, I need this as the QR Output:

AAAA, BBBB, CCCC
---------------------------------------
ID1 xxxx xxxx xxxx xxxx
ID2 xxxx xxxx xxxx xxxx
ID3 xxxx xxxx xxxx xxxx
ID8 xxxx xxxx xxxx xxxx

DDDD, EEEE, FFFF
---------------------------------------
ID5 xxxx xxxx xxxx xxxx
ID6 xxxx xxxx xxxx xxxx

GGGG, HHHH, IIII
---------------------------------------
ID4 xxxx xxxx xxxx xxxx
ID7 xxxx xxxx xxxx xxxx

Can you help me with that?




-- 
Best regards,
Vladimir Stefanovic

Technical Details

Message-ID: <42b58fea$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <42b53c44$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,2345304f9fe81e42
X-Google-Attributes: gid10698b,public
X-Google-Language: FRENCH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
References: <42b53c44$1@newsgroups.borland.com>
Subject: Re: Making a QR report ...
Date: Sun, 19 Jun 2005 17:32:00 +0200
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 82.117.212.65
Message-ID: <42b58fea$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1119195114 82.117.212.65 (19 Jun 2005 08:31:54 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message