Text Truncated

[doll1999]

Hy Everybody....

I'm new of the forum, and also new of iReport...

I have a question...

I'm using iReport to represent data contained into a Database....Sometimes is ok, but sometimes tha data are truncated...

For example, i would like to represent this:

Code:

ITEM "<automatically>" param:""C:\Documents and Settings\fdelfino\Desktop\adoDBDoku_35.doc""@

 

But i obtain this:

Code:

[code] ITEM "<automatically>" param:""C:\Documents and

Can you help me???What i have to do????

Thanx in advance

Francesco, form Italy

[vinays84]

Please post the DB table DDL and query you are using. Also specify the DB and verify that the DB actually contains the proper data (run the query outside of iReport) to ensure that it is iReport's JDBC access that is the problem.

[doll1999]

Hy Vinay...

Thanx for your help...

The Database i'm using is SQL Server 2000...

The query is a simple

Code:

Select *
from nameView

and it works outside of iReport...But works also inside iRepors, but give me (sometimes) the value truncated...

 

I create a view with a Java Application; The view is not empty and is possible to see the element inside the view not truncated...

 

So, maybe there is some command in iReport to get Dynamic the results????

[vinays84]

Post the DDL: the names and data type of the columns in your table...specifically the one which you are trying to access.

[doll1999]

Hi... :-)

The ddl is as follows:

Code:

Create table nameTable (id int primary key,
                          Instance_Name varchar(251),
                          Model_Name varchar(251),
                          Model_Type varchar(251),
                          Description varchar(255),
                          Comment varchar(255),
                          Denomination varchar(255),
                          PersonalKosten decimal (28),
                          Index int);

The value which are represented truncated are the value "string"...

There is no problem to represent all values, also the truncated values, with iReport...THe only thingh is, if possible,

to have the data not truncated...

Thanx

[Giulio Toffoli]

Data is usually truncated if there is not space in the textfield showing it.

 

If you want the textfield automatically grown (in height) to fit space required by a long text, set the checkbox "stretch with overflow" in the textfield attributes.

 

bye

 

Giulio

[doll1999]

Hy Giulio...

Thanx so much for your help, is exactly what i want...

But now i have a problem...

If i select "stretch with overflow" the text is automatically grown (in height), but the results in my report (pdf) is overwrited at the follow resuts...

What can i do????

Francesco

[Pedja]

Set the "Position type" property on all the elements below the one that stretches to "Float".