Eclipse Community Forums: BIRT » SQL Text and Birt formating

Home » Archived » BIRT » SQL Text and Birt formating

SQL Text and Birt formating [message #650310]

Mon, 24 January 2011 05:55

Eclipse User

Hello,

I am reading a text type column from MS Sql database to Birt. On HTML everything looks fine but when I print it to PDF the text doesn't look ok anymore.

In PDF I don't get any line changes.

Datatype for the Birt element is String.

edit: Actually in PDF I only get the first line.

[Updated on: Mon, 24 January 2011 06:10] by Moderator

Re: SQL Text and Birt formating [message #650391 is a reply to message #650310]

Mon, 24 January 2011 12:16

Eclipse User

What is in the text?

Jason

On 1/24/2011 5:55 AM, Ville Kaukonen wrote:
> Hello,
>
> I am reading a column text from MS Sql database to Birt. On HTML
> everything looks fine but when I print it to PDF the text doesn't look
> ok anymore.
> In PDF I don't get any line changes.
> Datatype for the Birt element is String.
>

Re: SQL Text and Birt formating [message #650466 is a reply to message #650391]

Tue, 25 January 2011 01:44

Eclipse User

Basically it's text saved from normal html text box to database. It's in MS SQL Text type column.

So I believe that text comes with char(13)+char(10) line changes. Or atleast that has been common earlier. I tried to replace those marks in Birt with a placeholder, but I saw no replacement. dataSetRow["Lisätietoja"].replace(String.fromCharCode(13)+String.fromCharCode(10), "</ br>")

Also I tested to export the document to word. There the lines changes worked just fine.

http://gdp.kapsi.fi/pics/Birt_problem.JPG

Example of my problem.

[Updated on: Tue, 25 January 2011 02:42] by Moderator

Re: SQL Text and Birt formating [message #650589 is a reply to message #650466]

Tue, 25 January 2011 10:48

Eclipse User

I did not get the attachment. Are you using a text box or a dynamic
text box report item in the design to display it?

Jason

On 1/25/2011 1:45 AM, Ville Kaukonen wrote:
> Basically it's text saved from normal html text box to database. It's in
> MS SQL Text type column.
> So I believe that text comes with char(13)+char(10) line changes. Or
> atleast that has been common earlier. I tried to replace those marks in
> Birt with a placeholder, but I saw no replacement.
> Also I tested to export the document to word. There the lines changes
> worked just fine.
>
>
> Example of my problem.

Re: SQL Text and Birt formating [message #650696 is a reply to message #650589]

Wed, 26 January 2011 02:02

Eclipse User

Alright!

Yeah I had just drag and dropped the data set from the data source menu to the project. Now I added a new Dynamic Text box and bind it to data source. I actually had tried this before, but i got reference errors. Now that I did the biding correctly on the dynamic textbox, the text output was like magic.

So problem solved. Thank you very much.

[Updated on: Wed, 26 January 2011 03:12] by Moderator

Previous Topic:	Properties file
Next Topic:	Round average aggregation on chart

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 05:01:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter