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.

Basic calc. question

3 posts in PB Infomaker Report Writer Last posting was on 1999-06-11 05:22:28.0Z
Richard Posted on 1999-06-07 07:26:06.0Z
Newsgroups: sybase.public.infomaker.general
From: "Richard" <georgehills2@worldnet.att.net>
Subject: Basic calc. question
Date: Mon, 7 Jun 1999 00:26:06 -0700
Lines: 5
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_m2ljTbLs#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6245
Article PK: 240181

I want to group by year or month of the incidate_date. How to I create a
calc. so I can extract the year (01/01/xxxx), or the month (01/xx/1999)?
Thanks.


Terry Dykstra Posted on 1999-06-07 15:00:49.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Basic calc. question
Date: Mon, 7 Jun 1999 09:00:49 -0600
Lines: 16
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_XrXuuXPs#GA.267@forums.sybase.com>
References: <348_m2ljTbLs#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6244
Article PK: 240180

To create a group in your report based on a computation:
Rows, Create group: drag any column over and then double-click on that
column. This will bring up the 'Modify Expression' screen, which allows you
to create an expression like: month(indicate_date)

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

Richard wrote in message ...
>I want to group by year or month of the incidate_date. How to I create a
>calc. so I can extract the year (01/01/xxxx), or the month (01/xx/1999)?
>Thanks.
>
>


Ewa MN Posted on 1999-06-11 05:22:28.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 11 Jun 1999 01:22:28 -0400
From: Ewa MN <knowacz_Nospam@Anglefire.com>
Reply-To: knowacz@angelfire.com
Organization: somewhere in the bush
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Basic calc. question
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Message-ID: <348_37609D14.7625@Anglefire.com>
References: <348_m2ljTbLs#GA.267@forums.sybase.com> <348_XrXuuXPs#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6216
Article PK: 240152


Terry Dykstra wrote:
>
> To create a group in your report based on a computation:
> Rows, Create group: drag any column over and then double-click on that
> column. This will bring up the 'Modify Expression' screen, which allows you
> to create an expression like: month(indicate_date)
>

Hello,
I think that in order for the group to work properly, the sorting has
also to be based on the same criteria, otherwise the report may show the
same groups appearing in couple of places, depending on how the data was
retrieved from the database.

Regards,
Eva