[CLOSED]Data not displaying in -HTMLFORM in WF8104
Hi All, I am trying to display the data in -HTMLFORM by using the HTMTABLE format but data not displaying when i used the hold file with in the htmlform like below. Here is my code. Please suggest. Thanks!
TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY BY PRODUCT
HEADING
"Sales Report"
FOOTING
"Sales Report - Page <TABPAGENO"
ON TABLE HOLD AS H1 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
DEFMACRO=A, STYLE=BOLD, SIZE=12, $
DEFMACRO=BI, STYLE=BOLD+ITALIC, COLOR=PURPLE, $
DEFMACRO=COND0001, WHEN=N3 GT 0, JUSTIFY=LEFT, BACKCOLOR='LIME', $
TYPE=REPORT,HFREEZE=TOP,SCROLLHEIGHT=3.45, $
TYPE=HEADING, MACRO=A, $
TYPE=FOOTING, MACRO=BI, COLOR=BLACK, $
TYPE=DATA, COLUMN=N1, MACRO=BI, $
TYPE=DATA, COLUMN=N2, MACRO=COND0001, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<HTML>
<BODY>
<table border="0" style="font-size:11px;font-family:arial;">
<tr>
<td>
!IBI.FIL.H1;
</td>
</tr>
</table>
</BODY>
</HTML>
-HTMLFORM END
-EXIT
This message has been edited. Last edited by: koti,
WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD
September 16, 2015, 06:05 PM
Waz
The issue swill be related to the use of HFREEZE.
I think it is because you are holding as HTMTABLE with HFREEZE and HFREEZE needs js files to be available.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 17, 2015, 09:51 AM
GavinL
Yea, your problem is defiantly HFREEZE. You might want to look at this:
They are using HFREEZE within a HTMTABLE and displaying it within an HTMLFORM.
This message has been edited. Last edited by: GavinL,
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
September 18, 2015, 05:15 AM
koti
Yes, the issue because of HFREEZE. I removed this from my code and its working fine. Thanks for your suggestions.
WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD
September 18, 2015, 09:07 AM
Shahram
You could also keep the HFREEZE but hold the report as FORMAT HTML.
All Releases All OS, All Outputs
September 18, 2015, 09:44 AM
Tony A
You can still utilise HFREEZE (and AHTML) via HTMLFORM but you would need to add libraries using the !IBI.OBJ.aaaa; syntax as described in the link that Gavin gave above. It just requires you to read and understand the requirements.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10