 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Total Records in last Page of PDF
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Total Records in last Page of PDF Read-Only TopicGo | Search | Notify | Tools |
| Total Records in last Page of PDF | Login/Join |
| Gold member |
Hi, I have requirement where in my output looks like below : COl Col2 Col3 ------------------------------- aaa tablet1 Date1 tablet2 -- bbb tablet3 Date2 tablet4 --- The above output has been achieved. In the footer , i need the output like below : Total Records = 2 (Line1) * Dash (--) Represents No Data Available. (Line2) This report requires secure handling. (Line3) Page 1 of 9 (Line4) Here , Line1 represents the total no of records (that is distinct) .The distinct records have been identified as well.But Line1 alone need to be present in the last page of the PDF. Whereas the others Line2,Line3,Line4 should appear in every page. The code i use to get the above output except (line1) is below  line 1 appears in every page)FOOTING BOTTOM "Total Records =<+0>&NLINES" "* Dash (--) Represents No Data Available." "This report requires secure handling." "Page I have tried ON TABLE SUBFOOT , but it appears in a new page. Have tried PAGE_BREAK as well. It does not work as i need. Appreciate your help. Thanks! Janani WebFOCUS 7.6.9 Windows Excel, HTML, PDF | ||
|
| Expert |
Create a new sort field (NEW_SORT) which has a constant value then do a ON NEW_SORT SUBHEAD... I hope that helps... Doug
| |||||
|
| Virtuoso |
You might be able to do a COMPUTED field based on the TABPAGENO field that either contains the footing text or a blank. Then you can embed that computed field in your footing. Something like this:
TABLE FILE CAR
SUM
CNT.CAR WITHIN TABLE NOPRINT
COMPUTE CARTOT/A5=FTOA(CNT.CAR,'(D2)',CARTOT); NOPRINT
COMPUTE PG1FOOT/A50=IF TABPAGENO EQ 1 THEN 'Appears on Page 1 only: Total Records: '|CARTOT ELSE ''; NOPRINT
BY COUNTRY
BY CAR
ON COUNTRY PAGE-BREAK
FOOTING BOTTOM
"<PG1FOOT "
"Page <TABPAGENO of <TABLASTPAGE "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=10, STYLE=NORMAL, $
TYPE=FOOTING, JUSTIFY=CENTER,$
ENDSTYLE
END
Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Gold member |
Thanks Darin! It worked ! Thanks! Janani WebFOCUS 7.6.9 Windows Excel, HTML, PDF | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Total Records in last Page of PDF
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Total Records in last Page of PDFCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |