I have an report with a wide alphanumeric column. Upon converting to an Active Report, the style sheet WRAP and SQUEEZE properties have no effect. How can I get either of these properties to work with Active Report enabled?

Thank you,

John

This message has been edited. Last edited by: <Emily McAllister>,

hi john,

Does active report mean AHTML format????
Because i had a hard time wrapping the long Alphanumeric columns in PDF Format.

Did you try:

  
-* File Wrap.fex
TABLE FILE CAR
PRINT MODEL MODEL MODEL
BY COUNTRY BY CAR
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=OFF, ORIENTATION=PORTRAIT, GRID=ON, size=9, $
TYPE=REPORT, COLUMN=N3, WRAP=1.00, $
TYPE=REPORT, COLUMN=N4, WRAP=0.7, $
TYPE=REPORT, COLUMN=N5, WRAP=0.5, $
ENDSTYLE
END

John,

I was asked this question during my presentation at Summit. Was that you? The question was whether or not Active Reports supports WRAP and SQUEEZE settings. Since I do not have a license for AHTML I never have tried this. I assumed it would but it looks like I was wrong. Unfortunately I can't do testing to see how to get around this.

Does anyone else have an Active Reports license to test this?

Danny,

I tried your suggestion, but it had no effect.

Thank you,

John

JohnB,

Make sure your HEADINGS are not longer than the report columns; that will stretch out the columns...

Create a new column and SUBSTR/EDIT the original.

Make sure "NOT" to use a AnV column, change it to An...

Make sure SQUEEZE=ON

Tom


EDIT:

Heres some code, try it and notice that the HEADING does to the columns. Now split the HEADING into 2 lines and the columns condense.
We had this problem with images...

  
DEFINE FILE CAR
  X_COST/P13.2M = DEALER_COST;
  Y_COST/P13.2M = RETAIL_COST;
  DESC/A50      = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA';
END
TABLE FILE CAR
HEADING
"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
SUM
	X_COST NOPRINT
	Y_COST NOPRINT
BY COUNTRY AS ''
SUM
DEALER_COST/P13.2M  
RETAIL_COST/P13.2M  
DESC                
BY COUNTRY   PAGE-BREAK
BY CAR  
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
$
TYPE=TITLE,
STYLE=BOLD,
$
ENDSTYLE
END
-EXIT

This message has been edited. Last edited by: Tom Flynn,

Tom,

The width of the heading was not the cause -- it's only about a 1/4 of the width of the report.

John

Hey JohnB,

Make sure you are not using AnV columns.
How big is the alphanumeric column you mentioned?

An example would be great!

I'll check over the weekend for your response...

Have a Safe & Happy 4th...

Tom

John,

After running some tests and looking at the (very complicated) HTML source produced by the HOLD FORMAT AHTML, I think that there are 2 conclusions:
1. The output being HTML, the WRAP attribute is ignored (not so in PDF, Arvind).
2. The HTML+Javascript generated by WF causes the columns to not wrap even if the output page is wider than your screen.

So, if you are intent on having the possibility to manage the column width of your Active Reports, you should put in a NFR.

Tom,

I believe Daniel is correct.

John

I know this is a really old post, but it still came up early in the results for me. The solution I found is that you have to change the TYPE for AHTML reports.

In other words, this works for Excel:

TYPE=REPORT, COLUMN=N5, WRAP=4, $  

But in AHTML, to get it to wrap, you have to use TYPE=DATA:

TYPE=DATA, COLUMN=N5, WRAP=4, $  

It's silly that this is the way it is, since it's completely non-intuitive, but it's a workaround.