Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Output to PDF when using HTMLFORM
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Output to PDF when using HTMLFORM
 Login/Join
 
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, 2008Reply With QuoteReport This Post
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.


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 137 | Registered: October 19, 2010Reply With QuoteReport 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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.