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.

the number of rows returned from sql before filter

2 posts in PB Infomaker Report Writer Last posting was on 1998-09-22 17:47:13.0Z
Henry Lau Posted on 1998-09-22 16:33:06.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 22 Sep 1998 10:33:06 -0600
From: Henry Lau <hlau@objectworks.com>
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
MIME-Version: 1.0
Subject: the number of rows returned from sql before filter
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 11
Message-ID: <348_3607D142.7DA67F9C@objectworks.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6890
Article PK: 242920

I would like to include a field in the report to state the number of
rows returned from the SQL, but the report has a filter that limited the
amount of rows displayed and this changed the number of rows in the
primary buffer. For example, the SQL returns 100 rows of data and the
Infomaker filter filited out 99 rows. Is there anyway to get a hold of
the number 100 and report this as a field in the report?


Terry Dykstra [TeamPS] Posted on 1998-09-22 17:47:13.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: the number of rows returned from sql before filter
Date: Tue, 22 Sep 1998 11:47:13 -0600
Lines: 20
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_0xjY$ck59GA.190@forums.powersoft.com>
References: <348_3607D142.7DA67F9C@objectworks.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6889
Article PK: 242919

Other than placing a nested report on the report that uses a 'select
count(*) from table' (mimicking the sql of the original report) , I don't
see a way of doing this. PB has a function called filteredcount() that
contains the number of rows filtered, but it is not accessible in a report
(i.e. PB datawindow).

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Henry Lau wrote in message <3607D142.7DA67F9C@objectworks.com>...
>I would like to include a field in the report to state the number of
>rows returned from the SQL, but the report has a filter that limited the
>amount of rows displayed and this changed the number of rows in the
>primary buffer. For example, the SQL returns 100 rows of data and the
>Infomaker filter filited out 99 rows. Is there anyway to get a hold of
>the number 100 and report this as a field in the report?
>