Format Text Field-End of Line/Cariage Return

[2002 JI Open Discussion]

By: Ryan - louier79

Format Text Field-End of Line/Cariage Return

2003-09-02 15:11

Hello,

 

I am filling a text field in a report and I would like to keep the format (tabs, spaces, EndOfLine/Cariage Return). The datasource is coming from an Oracle DB.

 

Can anyone please tell me how to maintain the text format?

 

Example

--------

Text:

See

Dog

Run

 

Current Output

--------------

See Dog Run

 

Desired Output

--------------

See

Dog

Run

 

Thank you for your assistance!

 

 

 

 

By: Ryan Johnson - delscovich

RE: Format Text Field-End of Line/Cariage Return

2003-09-02 15:19

JR at least picks up and displays text with multiple lines - I don't know about tabs. I would guess you're importing it to HTML and the web browser is causing you the trouble

 

Ryan

 

 

 

 

By: Ryan - louier79

RE: Format Text Field-End of Line/Cariage Return

2003-09-02 15:39

Well, I guess the issue is with the Oracle DB. The field in the Oracle table is:

 

field1

-----

See Dog Run

 

I tried doing:

field2

-----

See "n"Dog "n"Run

 

But the output was: See "n"Dog "n"Run

 

So, I guess the correct question is what is the correct syntax for Oracel and JasperReport for carriage return/EndofLine?

 

My jasper report is being exported to an PDF file.

 

Thank you again for your assistance!!!

 

 

 

 

By: Ryan Johnson - delscovich

RE: Format Text Field-End of Line/Cariage Return

2003-09-02 15:46

Do you know for sure if the characters were stored correctly in the db? The example you gave doesn't look like it has multiple lines in it.

 

I don't use Oracle, but the command line SQL of my db (Firebird) displays the text as-is, CR/LF and all, so I would think Oracle's would, too. I'd check there next.

 

Ryan