SeanChivers
Technical User
Hi all, I have a field incoming from ODBC in 'CLOB' format (treated as memo field type) with HTML formating tags clumped in with the data.
Tags are viewed in the report so need to eliminate or change view to HTML. Cannot manipulate this field using a 'formula' even by assigning field to variable. 8.5 claims this field type can't be used in formula when I try. (wonder if later versions allow it?).
Alternative was to set field paragraph format Text Interpretation to HTML. This has worked. Problem now is that the HTML font size is too large, and other paragraph formatting like font size won't alter the char size. Results in this column much larger than all others. Not allowed to alter the other column char size to match. Seems like text is represented similar to a bitmap and unalterable.
Assuming I can't manipulate the field in a formula (as 8.5 says I can't), and neither can I alter the database field controls in any way from the db side, anyone know of a way to get round the HTML interpreted fixed font size issue within Crystal (or on the way in)? Or alternatively, a way to allow me to manipulate the field in a formula so I can scrub the tags. :/
Tags are viewed in the report so need to eliminate or change view to HTML. Cannot manipulate this field using a 'formula' even by assigning field to variable. 8.5 claims this field type can't be used in formula when I try. (wonder if later versions allow it?).
Alternative was to set field paragraph format Text Interpretation to HTML. This has worked. Problem now is that the HTML font size is too large, and other paragraph formatting like font size won't alter the char size. Results in this column much larger than all others. Not allowed to alter the other column char size to match. Seems like text is represented similar to a bitmap and unalterable.
Assuming I can't manipulate the field in a formula (as 8.5 says I can't), and neither can I alter the database field controls in any way from the db side, anyone know of a way to get round the HTML interpreted fixed font size issue within Crystal (or on the way in)? Or alternatively, a way to allow me to manipulate the field in a formula so I can scrub the tags. :/