Focal Point
[SOLVED] AHTML: "70 of 70 records, Page 1 of 2"

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

February 02, 2015, 03:37 PM
Doug
[SOLVED] AHTML: "70 of 70 records, Page 1 of 2"
Why does "70 of 70" show for all page? Run this code and see for yourself:
APP PATH IBISAMP
-RUN
WHENCE EMPLOYEE MASTER
WHENCE EMPLOYEE FOCUS
-RUN
TABLE FILE EMPLOYEE
PRINT
 DEPARTMENT    CURR_SAL      CURR_JOBCODE  ED_HRS
 BANK_NAME     BANK_CODE     BANK_ACCT     EFFECT_DATE
 DAT_INC       PCT_INC       SALARY        PAYINFO.JOBCODE
 TYPE          ADDRESS_LN1   ADDRESS_LN2   ADDRESS_LN3   ACCTNUMBER
 PAY_DATE      GROSS
BY FIRST_NAME
BY LAST_NAME
BY HIRE_DATE
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
END
I'll open a for this unless anyone has an acceptable, easy, workaround. I may use the workaround till the case gets resolved and implemented.

Thanks in advance, Doug

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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 02, 2015, 04:58 PM
Doug
I stil get "70 OF 70" when adding:
TYPE=REPORT, BORDER=LIGHT, FONT='ARIAL', SIZE=10, LINES-PER-PAGE=10,$

Maybe I'm barking up the wrong tree...

What I'm looking for is something like this, based on 70 rows in the report, 10 rows displayed per page:
"1 to 10 records of 70, Page 1 of 7"
"11 to 20 records of 70, Page 2 of 7"
"21 to 30 records of 70, Page 3 of 7"
I'm sure I did something like that in the past, using the features of WebFOCUS. I, also, did it by adding JavaScripting / ON TABLE HOLD AS REPORTX FORMAT HTMTABLE". But, i don't want to go the JS route.

This message has been edited. Last edited by: Doug,
February 02, 2015, 05:31 PM
Francis Mariani
That would be nice, but it looks like Active HTML reports does not do that. The 999 of 999 records is useful if the Active HTML Filters are used - the Filter available on each column...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 02, 2015, 05:55 PM
Doug
So, am I thinking of on-demand paging? What's the syntax for that? And, is it available in Active HTML?
February 04, 2015, 02:13 AM
Neelima
Hi Doug,

We can update the following line in irpcusf.js.

'paglinetext':"<%^%frcs-%lrcs records, Page %inds of %pgs%> <\/span>"

through that you can get your desire result.

as per your code, it will display

1-57 records, Page 1 of 2


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
February 06, 2015, 11:03 AM
Doug
Where is "irpcusf.js"? And woukd that change be applicable to / for all users?

Blind Note: More about "on-demand paging": DevStudio F1