Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Output to PDF when using HTMLFORM

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Output to PDF when using HTMLFORM
 Login/Join
 
Eforcier
Member
posted
Hi, we just upgrade our DEV environment to 7.6.11. I have a problem everywhere I'm using HTMLFORM in my code when I try to Output my report in PDF format. Is anything change since 5.3.2 on the way of using HTMLFORM.

I just produce a very simple program.

Like this I have no problem:

-HTMLFORM BEGIN
-HTMLFORM END

TABLE FILE FISCAL_YEAR

PRINT FY_FISCAL_YEAR

ON TABLE PCHOLD FORMAT PDF

END


But as soon as I put any code between the BEGIN and the END of the HTMLFORM, my output looks like PDF "code".


-HTMLFORM BEGIN


-HTMLFORM END

TABLE FILE FISCAL_YEAR

PRINT FY_FISCAL_YEAR

ON TABLE PCHOLD FORMAT PDF

END

The output look like this:

%PDF-1.4 6 0 obj << /Length 7 0 R >> stream BT /F1 1 Tf ET 0 g /GS1 gs 0 Tc 0 Tw 0 G 0 J 0 j 1 w 10 M []0 d 1 i BT /F1 1 Tf 12 0 0 12 18 762 Tm (PAGE )Tj 12 0 0 12 61 762 Tm ( 1)Tj 12 0 0 12 18 726 Tm (FY_FISCAL_YEAR)Tj ET 0.00 0.00 0.00 RG 18 720 m 118 720 l S BT 12 0 0 12 18 702 Tm (2000)Tj 12 0 0 12 18 690 Tm (2001)Tj 12 0 0 12 18 678 Tm (2002)Tj 12 0 0 12 18 666 Tm (2003)Tj 12 0 0 12 18 654 Tm (2004)Tj 12 0 0 12 18 642 Tm (2005)Tj 12 0 0 12 18 630 Tm (2006)Tj 12 0 0 12 18 618 Tm (2007)Tj 12 0 0 12 18 606 Tm (2008)Tj 12 0 0 12 18 594 Tm (2009)Tj 12 0 0 12 18 582 Tm (2010)Tj 12 0 0 12 18 570 Tm (2011)Tj 12 0 0 12 18 558 Tm (2012)Tj 12 0 0 12 18 546 Tm (2013)Tj 12 0 0 12 18 534 Tm (2014)Tj 12 0 0 12 18 522 Tm (2015)Tj 12 0 0 12 18 510 Tm (2016)Tj 12 0 0 12 18 498 Tm (2017)Tj ET endstream endobj 7 0 obj 779 endobj 8 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents 6 0 R >> endobj 4 0 obj

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


WebFOCUS 5.3.2
 
Posts: 5 | Registered: August 25, 2008Report This Post
dbeagan
Platinum Member
posted Hide Post
Testing in 7.7.01 I get similar behavior.

Then I tried:
 
TABLE FILE CAR
PRINT CAR
END
TABLE FILE GGSALES
COUNT DOLLARS
ON TABLE PCHOLD FORMAT PDF
END


And I get:
PAGE 1 
 
COUNTRY 
ENGLAND 
JAPAN 
ITALY 
W GERMANY 
FRANCE 
%PDF-1.4 6 0 obj << /Length 7 0 R >> stream BT /F1 1 Tf ET 0 g /GS1 gs 0 Tc 0 Tw 0 G 0 J 0 j 10.000000 w 10 M []0 d 1 i q 0.050000 0 0 0.050000 0 0 cm BT /F1 1 Tf 240 0 0 240 360 15280 Tm (PAGE )Tj 240 0 0 240 1224 15280 Tm ( 1)Tj 240 0 0 240 360 14680 Tm (Dollar Sales)Tj 240 0 0 240 360 14480 Tm (COUNT)Tj ET 0.00 0.00 0.00 RG 360 14160 m 2088 14160 l S BT 240 0 0 240 1512 13840 Tm (4317)Tj ET Q endstream endobj 7 0 obj 373 endobj 8 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents 6 0 R >> endobj 4 0 obj << /ProcSet [/PDF /Text /ImageC] /Font << /F1 9 0 R >> /XObject << >> /ExtGState << /GS1 2 0 R >> >> endobj 5 0 obj << /Types /Pages /Kids [8 0 R ] /Count 1 /MediaBox [0 0 612 792] >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Encoding /WinAnsiEncoding /Name /F1 /BaseFont /Courier >> endobj 3 0 obj << /Type /Halftone /HalftoneType 1 /HalftoneName (Default) /Frequency 60 /Angle 45 /SpotFunction /Round >> endobj 2 0 obj << /Type /ExtGState /SA false /OP false /HT /Default >> endobj 1 0 obj << /Type /Catalog /Pages 5 0 R >> endobj xref 0 10 0000000000 65535 f 0000001093 00000 n 0000001014 00000 n 0000000882 00000 n 0000000545 00000 n 0000000674 00000 n 0000000010 00000 n 0000000442 00000 n 0000000464 00000 n 0000000768 00000 n trailer << /Size 10 /Root 1 0 R >> startxref 1148 %%EOF


So the browser doesn't do HTML and PDF output together in the same output -- at least not without taking further measures such as creating an iframe.


WebFOCUS 8.2.06
 
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010Report This Post
<JG>
posted
If you want to direct PDF and HTML or any mixed formats to an HTMLFORM
then you need to code iframes that call the reports, and the browser must be set to
open the objects in the browser via a plugin not in the application

For example create a fex called thisfex

 -DEFAULT &TARGET='FORM'
-GOTO &TARGET.EVAL
-REP1
TABLE FILE CAR
SUM DCOST BY COUNTRY
ON TABLE PCHOLD AS HTMHOLD FORMAT HTML
END
-RUN
-EXIT
-REP2
TABLE FILE GGSALES
COUNT DOLLARS
ON TABLE PCHOLD AS PDFHOLD FORMAT PDF
END
-RUN
-EXIT
-FORM
-HTMLFORM BEGIN
<body>
<iframe name=frame1 height=50% width=100% frameborder=0 src="/ibi_apps/WFServlet?IBIF_ex=thisfex&|TARGET=REP1"></iframe>
<iframe name=frame2 height=50% width=100% frameborder=0 src="/ibi_apps/WFServlet?IBIF_ex=thisfex&|TARGET=REP2"></iframe>
</body>
-HTMLFORM END
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Output to PDF when using HTMLFORM

Copyright © 1996-2020 Information Builders