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.

Select Top 10

2 posts in PB Infomaker Report Writer Last posting was on 1999-02-26 21:09:15.0Z
haakon.bruusgaard Posted on 1999-02-26 09:46:35.0Z
Newsgroups: sybase.public.infomaker.general
From: haakon.bruusgaard@lightware.no
Subject: Select Top 10
Date: Fri, 26 Feb 1999 09:46:35 GMT
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 5
Message-ID: <348_36d66d18.77420645@10.1.1.12>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6527
Article PK: 241515

Hello.
I am a newbee to Infomaker. I wuld like to select my customers and
select the "Top 10" of those.
Anyone have a great idea ?
It would make a man happy if u did.
Regrds, HÃ¥kon


Terry Dykstra Posted on 1999-02-26 21:09:15.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Select Top 10
Date: Fri, 26 Feb 1999 14:09:15 -0700
Lines: 19
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_qFhO1vcY#GA.202@forums.powersoft.com>
References: <348_36d66d18.77420645@10.1.1.12>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6523
Article PK: 241509

SQL doesn't have any functions that can really handle this. But a quick an
dirty way is to select your customers and then in the report sort by the
top10 field in descending order (i.e. greatest first) Then place a filter
on the report: getrow() < 11, which will limit the report to the first 10
rows.

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

haakon.bruusgaard@lightware.no wrote in message
<36d66d18.77420645@10.1.1.12>...
>Hello.
>I am a newbee to Infomaker. I wuld like to select my customers and
>select the "Top 10" of those.
>Anyone have a great idea ?
>It would make a man happy if u did.
>Regrds, HÃ¥kon