Focal Point
[SOLVED] Pagination giving wrong set of records

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6311011113

December 20, 2008, 09:32 AM
pankaj
[SOLVED] Pagination giving wrong set of records
Per page it should show the no. of records avaiable.But for eg:it is showing 237 of 237 records ideally it should be 25 of 237 records

Please Help

This message has been edited. Last edited by: Kerry,


Webfocus 7.6
Windows Nt
Excel, PDF, HTML
December 21, 2008, 05:48 AM
FrankDutch
What?

Post some code example based on the CAR database.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

December 21, 2008, 04:44 PM
Waz
Ditto with Frank.

More info.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 21, 2008, 08:54 PM
StuBouyer
quote:
Originally posted by pankaj:
Per page it should show the no. of records avaiable.But for eg:it is showing 237 of 237 records ideally it should be 25 of 237 records

Please Help


Pankaj,

I assume you referring to Active Reports and pagination bar (ie 237 of 237 Records Page 1 of 3). The records section does not show the number of records per page, but the filtering level of the active reports. When you first open the report there is no filtering therefore you see 237 of 237 Records. Add a filter and you will see the number change.

Currently there is no way to do what you want with the default active report.

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
December 23, 2008, 01:56 AM
pankaj
Hi,
The below code is based on Car database,and pagination is applied on it,which is showing 18 of 18 records.

TABLE FILE CAR
PRINT
COUNTRY
SEATS
DEALER_COST
RETAIL_COST
SALES
HEADING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END


Regards
Pankaj


Webfocus 7.6
Windows Nt
Excel, PDF, HTML
December 23, 2008, 05:00 AM
<JG>
Pankaj,

Please read what Stu posted.

It is not possible to display what you want using AHTML as the numbers based on your filters
not what page you are on.