Hi,
I'm having a issue with a excel column heading which is relatively long(see below). It prints with a special character(square box) in the heading where I have commas to print the heading in next line.

TABLE FILE TABLE A
SUM
EXER_NUM_US AS 'No.of Policies,Exercising,GPO - YTD (US)'
BY YEAR
BY ISS_YR
END
-RUN

IT PRINTS AS "No.of Policies(square box)Eligible for(square box)GPO - YTD (US)"

When i double click the column in excel it looks good but when we first open the report it shows as above and the user is not happy with it.

Any help or suggestions is appreciated!

Thank you
RK

This message has been edited. Last edited by: Kerry,

The following shows perfectly OK run from 7.7.03 to MS Excel 2007

TABLE FILE IBISAMP/CAR
  SUM RCOST
      DCOST
   BY COUNTRY AS 'No.of Policies,Exercising,GPO - YTD (US)'
   BY CAR
   BY MODEL
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN

What version of MS Excel are your end users / you using?

T

TOny's code works perfectly in both Excel 2000 and Excel 2007, when run from 7.7.02.

Are you using an older version of excel than 2000?

we use EXCEL 2007. The problem is, this error doesn't occur all the time. Most of the time it occurs in caster jobs. When I run the report it print's ok but the same report from caster sometimes it prints out with small square character. Not sure why this error is inconsistent.

Any suggestions?

How did you get the text in the title, type it or cut and paste ?

Just a thought ... have you tried removing the commas and using "TYPE=REPORT,COLUMN=N3,WRAP=nnn,$ " ?

Mary,
I used WRAP & Squeeze and it does wrap but the text still print in single line and most of it is hidden because I wrapped. Full column title is not visible because of WRAP.

Waz,
I typed it.

quote:

I used WRAP & Squeeze

Use WIDTH with WRAP not SQUEEZE

T

I now used WRAP and WIDTH in my stylesheet. It works that way I wanted in development and hoping it will look the same in caster too once its scheduled.

Thank you Tony!

A pleasure

T