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] HFREEZE in 8.2 Portals + Chrome?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] HFREEZE in 8.2 Portals + Chrome?
 Login/Join
 
Member
posted
Hello!

Has anybody successfully integrated a report with an HFREEZE into an 8.2 Portal? I have a report that was running perfectly in 8.1, but shows up blank now.

For example, the following code previews correctly in App Studio, but shows a blank page in the portal:
 
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET STYLE *
     INCLUDE = warm,
$
TYPE=REPORT,
     HFREEZE=TOP,
$
ENDSTYLE
END
 


Has anybody gotten HFREEZE working lately?

Thanks!
Jay

This message has been edited. Last edited by: Jay Ervin,


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 17 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jay

I just put your code into a portal on version 8.2.06 gen 71 and it worked just fine. That is the only version of 8.2 I have running.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1585 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Run as expected in both 8201M gen240 and 8204M gen33 but with the below code ran from Domains Content not from EDA (RS) from which the first INCLUDE syntax is for

TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET STYLE *
-*     INCLUDE = warm,
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=REPORT,
     HFREEZE=TOP,
$
ENDSTYLE
END


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2189 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
EDIT: This was resolved by adding SCROLLHEIGHT=AUTO to the stylesheet.



So I think I'm dealing with two issues. One has to do with our Portal style, which I'll continue to research. The other, however, has to do with a MORE line and HFREEZE:

TABLE FILE CAR
SUM
    DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
WHERE SEATS EQ 2;

ON TABLE HOLD AS HLDCOUPE FORMAT XFOCUS
END

TABLE FILE CAR
SUM
    DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
WHERE SEATS NE 2;

ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML

ON TABLE SET STYLE *
     INCLUDE = warm,
$
TYPE=REPORT,
     HFREEZE=TOP,
$
ENDSTYLE
MORE
	FILE HLDCOUPE
END


If the HFREEZE is commented out of this code, the table generates correctly. Uncommented, it does some weird formatting and doesn't actually freeze the top row.

Any thoughts on why MORE is affecting HFREEZE?

Thanks!
Jay

This message has been edited. Last edited by: Jay Ervin,


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 17 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Member
posted Hide Post
Sorry for the brief diversion! Back to the original issue...

I've narrowed it down a bit. The code runs in IE 11, but it won't run in an Chrome version 77. As far as I can tell, IBI only officially supports up to 64. Can anybody run this in another Chrome version and let me know if it runs correctly?

TABLE FILE CAR
SUM
    DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
WHERE SEATS EQ 2;

ON TABLE HOLD AS HLDCOUPE FORMAT XFOCUS
END

TABLE FILE CAR
SUM
    DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
WHERE SEATS NE 2;

ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML

ON TABLE SET STYLE *

	INCLUDE = warm,$
		TYPE=REPORT, HFREEZE=TOP, SCROLLHEIGHT=AUTO, $
ENDSTYLE
END
MORE
	FILE HLDCOUPE
END


Thanks again!


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 17 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Not related to version. I have GC 77.0.3865.90 and it does react the same as with IE 11.737.17763.0 when using SCROLLHEIGHT=AUTO

Using the below freeze the header on a 2 inches height report no matter the browser
TABLE FILE CAR
SUM DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
	INCLUDE = warm,$
TYPE=REPORT,
 HFREEZE=TOP,
 SCROLLHEIGHT=2,
$
ENDSTYLE
END


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2189 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by MartinY:
Not related to version. I have GC 77.0.3865.90 and it does react the same as with IE 11.737.17763.0 when using SCROLLHEIGHT=AUTO

Using the below freeze the header on a 2 inches height report no matter the browser
TABLE FILE CAR
SUM DEALER_COST
    SALES
BY  COUNTRY
BY  CAR
BY  MODEL
BY  BODYTYPE
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
	INCLUDE = warm,$
TYPE=REPORT,
 HFREEZE=TOP,
 SCROLLHEIGHT=2,
$
ENDSTYLE
END


Thank you for checking that. It turns out that this error is specific to my user name, and my coworkers are seeing my code just fine, so I have at least gotten HFREEZE working for everyone else!

Thanks for all the help!


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 17 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HFREEZE in 8.2 Portals + Chrome?

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