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.

Column order in crosstab

2 posts in PB Infomaker Report Writer Last posting was on 1999-03-09 18:39:50.0Z
Amy Posted on 1999-03-08 17:52:40.0Z
Newsgroups: sybase.public.infomaker.general
From: "Amy" <akim@transportation.ucla.edu>
Subject: Column order in crosstab
Date: Mon, 8 Mar 1999 09:52:40 -0800
Lines: 3
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <348_rNp4cwYa#GA.132@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6506
Article PK: 241494

Is there any wasy to create a custom ordering of columns in a crosstab?


Terry Dykstra Posted on 1999-03-09 18:39:50.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Column order in crosstab
Date: Tue, 9 Mar 1999 11:39:50 -0700
Lines: 13
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_$8vOWvla#GA.75@forums.powersoft.com>
References: <348_rNp4cwYa#GA.132@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6502
Article PK: 241488

No. The only way you can really control the sorting, is by modifying your
select statement.
For example, if you have a crosstab that has the daily sales for a given
week, pull the daynumber, not the dayname in your select.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Amy wrote in message ...
>Is there any wasy to create a custom ordering of columns in a crosstab?
>
>