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.

duplicate records

2 posts in PB Infomaker Report Writer Last posting was on 1997-10-21 17:44:48.0Z
nmas Posted on 1997-10-21 15:54:01.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 21 Oct 1997 11:54:01 -0400
From: nmas <nmas@esri.ca>
Reply-To: nmas@esri.ca
Organization: ESRI Canada
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: duplicate records
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 8
Message-ID: <348_344CD019.333E@esri.ca>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7423
Article PK: 244482

Hello

I am using Infomaker 4.0 and I am having problems with duplicate
records. I have correctly calculated a computed field but now I only
want to see one instance of that record. Could you please help me find
a way to eliminate duplicate records?

Thank you in advance,

Nicole Mas
nmas@esri.ca


Terry Dykstra Posted on 1997-10-21 17:44:48.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: duplicate records
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Tue, 21 Oct 1997 13:44:48 -0400
Lines: 14
Message-ID: <348_01bcde51$240bc680$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_344CD019.333E@esri.ca>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7422
Article PK: 244478

Two options are available:
1) in your sql: SELECT DISTINCT ...(menu: Options, Distinct)
2) on the report create a group and move the fields from the detail band to
the group band.

Terry Dykstra (TeamPS)

nmas <nmas@esri.ca> wrote in article <344CD019.333E@esri.ca>...
> Hello
>
> I am using Infomaker 4.0 and I am having problems with duplicate
> records. I have correctly calculated a computed field but now I only
> want to see one instance of that record. Could you please help me find
> a way to eliminate duplicate records?