Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeping text format in large varchar in a report

Status
Not open for further replies.

papalpha

Programmer
Jul 31, 2002
26
US
I have a column that is a varchar2(4000) for the user to enter lots of text. This column is selected in two different reports. In one of them, it reflects all the carriage returns and/or tabs, in the other one it does not. I have checked the property palette of both and they are identical. Originally the one that does not show the carriage returns was set to Vertically Variable, but made it Expand like the other one and have also made all the surrounding frames to expand also. This made no difference.
Can anyone give me an idea of what to modify to make it reflect the carriage returns. This is in Reports 6i.
Thanks
 
Do you actually see in the SQL that exactly the same field is selected, and selected the same way? Is it possible that in one of the reports the field is selected with a function that strips off special characters? Try deleting and recreating the fields. Try using labels insted of the fields. The label text should be &<the_field_name_here>. The sure thing is that elasticity has nothing to do with the problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top