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.

Crosstab Query

2 posts in PB Infomaker Report Writer Last posting was on 1998-06-15 18:35:28.0Z
Christopher F Jackson Posted on 1998-06-13 14:51:47.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sat, 13 Jun 1998 10:51:47 -0400
From: Christopher F Jackson <cfjackson@earthlink.net>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: Crosstab Query
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 16
Message-ID: <348_35829202.31DFFEA5@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7069
Article PK: 243100

I use a lot of crosstab queries and I would like to know if there is a
way
to sort the columns is a crosstab in a certain order or does it just
produce them as it sees in in the database. I would even take
ascending or descending order

The analyst I send my reports to are use to seeing them in a specific
order any ideas would be appreciated. Reproduce tables like this but it
has to be in crosstab.

Holland Lincoln GWBridge Bayonne
Jan 300 400 500 600
Feb
Mar

Christopher F Jackson
Data Analyst
Port Authority of NY & NJ


Terry Dykstra [TeamPS] Posted on 1998-06-15 18:35:28.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Crosstab Query
Date: Mon, 15 Jun 1998 12:35:28 -0600
Lines: 32
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_PTYKcLIm9GA.195@forums.powersoft.com>
References: <348_35829202.31DFFEA5@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7061
Article PK: 243092

Crosstabs are difficult to manipulate. To change the order you can try to
change the Select statement so that the column header columns are prefixed
with a number or character, so that they will sort in ascending/ descending
order.
If you can change the crosstab from dynamic to static format, you can
rearrange columns, and rename the headers.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Christopher F Jackson wrote in message <35829202.31DFFEA5@earthlink.net>...
>I use a lot of crosstab queries and I would like to know if there is a
>way
>to sort the columns is a crosstab in a certain order or does it just
>produce them as it sees in in the database. I would even take
>ascending or descending order
>
>The analyst I send my reports to are use to seeing them in a specific
>order any ideas would be appreciated. Reproduce tables like this but it
>has to be in crosstab.
>
> Holland Lincoln GWBridge Bayonne
>Jan 300 400 500 600
>Feb
>Mar
>
>Christopher F Jackson
>Data Analyst
>Port Authority of NY & NJ
>