Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Multiple values in crosstab reports

2 posts in PB Infomaker Report Writer Last posting was on 1999-01-30 00:07:27.0Z
Lisa Trentham Posted on 1999-01-29 18:30:51.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 29 Jan 1999 11:30:51 -0700
From: Lisa Trentham <lisa@mail.ntu.edu>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Multiple values in crosstab reports
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <348_36B1FE5B.7B9492E1@mail.ntu.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6594
Article PK: 241583

I have two crosstab reports that use the same rows and columns but have
different values displayed. I would like to combine the two reports
into one report. However the two value columns use completely different
select statements and where clauses. Is there any way to use multiple
select statements in a single crosstab report?

Any help would be appreciated.


Terry Dykstra Posted on 1999-01-30 00:07:27.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Multiple values in crosstab reports
Date: Fri, 29 Jan 1999 17:07:27 -0700
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_0oSBxQ#S#GA.124@forums.powersoft.com>
References: <348_36B1FE5B.7B9492E1@mail.ntu.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6593
Article PK: 241579

You could try using a UNION to combine the two SELECT statements.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Lisa Trentham wrote in message <36B1FE5B.7B9492E1@mail.ntu.edu>...
>I have two crosstab reports that use the same rows and columns but have
>different values displayed. I would like to combine the two reports
>into one report. However the two value columns use completely different
>select statements and where clauses. Is there any way to use multiple
>select statements in a single crosstab report?
>
>Any help would be appreciated.
>
>
>