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.

IM 6.0 X-tab - missing selection criteria possibility

2 posts in PB Infomaker Report Writer Last posting was on 1998-02-13 19:38:34.0Z
Niels Johansen Posted on 1998-02-13 11:07:24.0Z
Newsgroups: sybase.public.infomaker.general
From: "Niels Johansen" <nielsdph@post4.tele.dk>
Subject: IM 6.0 X-tab - missing selection criteria possibility
Organization: DataPharm a/s
X-Newsreader: Microsoft Internet News 4.70.1155
Date: Fri, 13 Feb 1998 06:07:24 -0500
Lines: 10
Message-ID: <348_01bd3878$63ef4ca0$0e00a8c0@niels>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7273
Article PK: 243304

Help, please
Why can't I use selection criteria in a cross-tab report?
Do anyone know a way to come around this?
Example:
Table: Date, Time, Ordertype
Column: Ordertype
Row: Time
I would like to be able to create a cross-tab showing:

Hour/Ordertype
type 1 type 2 type 3

01 3 7 6
02
...
24 3 24 7

But only covering certain dates.


Terry Dykstra [TeamPS] Posted on 1998-02-13 19:38:34.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: IM 6.0 X-tab - missing selection criteria possibility
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 13 Feb 1998 14:38:34 -0500
Lines: 19
Message-ID: <348_01bd38bf$eb0f4f40$3301020a@tdykstra>
References: <348_01bd3878$63ef4ca0$0e00a8c0@niels>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7270
Article PK: 243300

I have no idea. To work around this you can use retrieval arguments using
a startdate and enddate. Or you can apply a filter on the report to select
only desired dates.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Niels Johansen <nielsdph@post4.tele.dk> wrote in article
<01bd3878$63ef4ca0$0e00a8c0@niels>...
> Help, please
> Why can't I use selection criteria in a cross-tab report?
> Do anyone know a way to come around this?
> Example:
> Table: Date, Time, Ordertype
> Column: Ordertype
> Row: Time
> I would like to be able to create a cross-tab showing:
>
> Hour/Ordertype
> type 1 type 2 type 3
>
> 01 3 7 6
> 02
> ...
> 24 3 24 7
>
> But only covering certain dates.
>