Exporting to Excel

[donv]

Hi
I would like to know if there is a Export Restriction on column length while exporting to Excel format.I mean when I was trying to export a web report to a Microsoft Excel format,I am not able to export the full Column Length of a particular report.
Eg: A column called "Comments" which has a length of 282 characters after being exported to Excel,is being truncated to 255 characters.Like wise much bigger columns are also being truncated.
Is there a way by which I can see the full column when the report is opened in Excel ? Can someone help me please ?


Thanks
Donv

 

[dgillz]

That is a limitation of excel. 255 is the max column width.
Call Uncle Bill.

If you really need to see it all create a couple of formulas:

Left({fieldname},255)

If length({fiedname})<=255 then &quot;&quot; else
Right({Fieldname},length({fieldname})-255)

Put these in adjacent columns on your report. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[donv]

Hello dgillz,
Thanks for your speedy response. I was trying to implement the above 2 formulas suggested by you.I am getting an Message &quot;Blob Field or Memo field cannot be used in a formula&quot;
Is it because The length of the &quot;fieldname&quot; is
varchar2(2000) ???
In that case can't I implement the above formulas?
Please let me know.

Thanking you,
Donv

 

[dgillz]

I am shocked that this did not work, but then again I have zero experience with Blob fields. Here is what George Peck's book says about blob fields:

&quot;Blob fields can be placed on a report only for display. They cannot be used or manipulated inside formulas. They won't even show up inside the formula editor field tree box.&quot;

I wish I knew what to tell you now but I don't. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office