I'm looking for anyone with a depth of knowledge of HFREEZE. I've read every little bit on Focal Point and throughout the IBI technical manuals about HFREEZE, but still only come up wth the same shallow use.

My problem is in controlling the output, particularly column widths. The best usage of the command for what I want to do is:

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
.
.
.
SQUEEZE=OFF,
$

TYPE=REPORT,
.
.
.
HFREEZE=TOP,
$

A photo or the redacted report is here:
http://farm5.static.flickr.com...753_785a0562cf_b.jpg

Notice in the column "DESCRIPTION" the amount of space to the right of "STAFF BEN-T/R OUT-ST". That is what I want to get rid of.

From the WebFOCUS documentation: SQUEEZE=OFF Assigns column widths based on the field format specified in the Master File. This value pads the column width to the length of the column title or field format descriptions, whichever is greater.

The field "DESCRIPTION" has a format of A20, and in fact the HTML output sets the CSS STYLE for that column to 20:

  
<COL STYLE="WIDTH:20em">

You can see that the data actually has 20 characters in it, but at least 1/3 of the column is padded out with whitespace.

I need to reduce this space to get the whole width of the report to fit into a screen width. The report when generated as standard HTML fits with room to spare, but this arbitrary padding makes the report too wide. I could write a complex JavaScript to handle this, but I shouldn't have to. Does anyone have experience with working with HFREEZE and getting output exactly as they like?

This message has been edited. Last edited by: <Kathryn Henning>,

You can use SQUEEZE to specify a column width in HTML output. Data that doesn't fit the specified width gets wrapped.

TABLE FILE CAR
 PRINT COUNTRY CAR MODEL BODYTYPE SEATS
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *
  TYPE=REPORT, HFREEZE=TOP, $
  TYPE=DATA, COLUMN=COUNTRY, SQUEEZE=1.0, $
  TYPE=DATA, COLUMN=CAR, SQUEEZE=1.2, $
  TYPE=DATA, COLUMN=MODEL, SQUEEZE=2.0, $
 ENDSTYLE
END

We are having similar issues with HFREEZE as discussed above. When we have HFREEZE=ON, the report width is considerably wider than with HFREEZE=OFF despite putting WRAP statements to force column widths. Any reason why HFREEZE would widen the columns on the report ?
Here is my code.......


TABLE FILE CAR
HEADING CENTER
"CAR DATA WITH HFREEZE"
" "
PRINT COUNTRY CAR MODEL
-* BODYTYPE SEATS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=endeflt,
$
TYPE=REPORT, HFREEZE=ON, $
TYPE=DATA, COLUMN=COUNTRY, WRAP=1.0, $
TYPE=DATA, COLUMN=CAR, WRAP=1.0, $
TYPE=DATA, COLUMN=MODEL, WRAP=1.0, $
ENDSTYLE
FOOTING CENTER
"RUN ON: &DATEDMYY AT: &TOD "
" "
END
-EXIT

Ian

Hi Ian,

Please open a case on InfoResponse Online so that we can look into this issue.

Thanks and regards,

Kathryn

Ian, what happens if you get rid of
INCLUDE=endeflt,
$

hfreeze works for me with squeeze and/or wrap

Hi Susannah,
Tried your suggestion with the removal of the INCLUDE=endeflt,
statement but makes no diffrence. Report is still wider with HREEZE=ON.
Regards,
Ian (in positively balmy London - 10 deg. C)

Have raised a case as suggested by Kathryn.

Try applying SQUEEZE to the column as a whole, and WRAP to the data cells within it:

type=report,column=DESCRIPTION,squeeze=on,$
type=data,column=DESCRIPTION,wrap=1.25,$

With a little bit of luck, when all the data is "thin" the column will contract, and when any of it is "fat" the column will expand up to 1.25 and the data will wrap within that.

Sorry Jack made no difference.
I put....
ON TABLE SET STYLE *
INCLUDE=endeflt,
$
type=report,HFREEZE=ON, $
type=report,column=DESCRIPTION,squeeze=on,$
type=data,column=DESCRIPTION,wrap=1.25,$
$
ENDSTYLE

I would open the hood (bonnet?) and analyze the generated HTML code.

Cut down the report to a few rows, run it with and without HFREEZE, and compare the generated HTML to see what's behind the difference in behavior. -- Of course, the gremlin may lie partly or entirely in dynamic changes to the style attributes when HFREEZE=ON is used, but it's a good starting point.

Will give it a whirl and let you know. Thanks Jack.

Hi Ian,

Sorry I missed this!

Do not forget that when you use WIDTH or WRAP they must be applied on a TYPE=REPORT.

Using your original sample code with this correction works fine for me on 7.7.03.

T

Sorry Tony - tried your suggestion using stylesheet below but HFREEZE=ON still gives a wider report (7.7.03).
Ian


ON TABLE SET STYLE *
INCLUDE=endeflt,
$
TYPE=REPORT, HFREEZE=ON, $
TYPE=REPORT, COLUMN=COUNTRY, WRAP=1.0, $
TYPE=REPORT, COLUMN=CAR, WRAP=1.0, $
TYPE=REPORT, COLUMN=MODEL, WRAP=2.0, $
ENDSTYLE

Hi Ian,

Running your code from above in 7.7.03, with your later styling produces a narrowed output -

TABLE FILE CAR
HEADING CENTER
"CAR DATA WITH HFREEZE"
" "
PRINT COUNTRY CAR MODEL 
-* BODYTYPE SEATS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=endeflt,
$
TYPE=REPORT, HFREEZE=ON, $
TYPE=REPORT, COLUMN=COUNTRY, WRAP=1.0, $
TYPE=REPORT, COLUMN=CAR, WRAP=1.0, $
TYPE=REPORT, COLUMN=MODEL, WRAP=2.0, $
ENDSTYLE
FOOTING CENTER
"RUN ON: &DATEDMYY AT: &TOD "
" "
END
-EXIT

Produces the one on the left. The one on the right is with the original code (e.g. TYPE=DATA plus your change to WRAP=2.0 for MODEL).



T

This message has been edited. Last edited by: Tony A,

Hi Tony, Agreed that it is narrower but still considerably wider than with HFREEZE=OFF.
I think Jack's earlier comment re analyzing the generated HTML code could be the go.
Cheers,
Ian

Indeed, and the main problem that exists is the inclusion of the two three <colgroup> tags. If you capture the HTML and comment these two three occurences out then your output is as you would wish.

Now the problem. You cannot affect the HTML produced without post parsing it as an HTMTABLE output.

T

This message has been edited. Last edited by: Tony A,

Yes I see what you mean Tony - as I said earlier I have raised a case so will see what comes out of that !!