[SOLVED] Problems printing a report

M3H0 · Last edited by M3H0 on Thu Aug 28, 2008 11:59 pm; edited 1 time in total

Hi everyone there,

I have developed a database (my first database) to manage the Bibliography research of my PHD. In that database, among many fields, there is one which contains the abstract of each article that I have.

I have created a report using Sun Report Builder 1.0.3 (by the way, I didn´t manage to install the last version of it). All the fields are correctly shown except the field corresponding to the abstract. The problem is that the text contained in that field (defined as LONGVARCHAR) is longer that the dimension of the field size that I defined in the Sun Report Builder´s design view and that´s why when I generate my report it shows a red arrow (Inside the blue circle in the atached figure) in which I have to click in order to scroll down the text. When I print the report the texts that are longer than the defined field size are truncated (it is printed only the text contained inside that field size, but not the whole text).

I guess it might be an option or a command, but I didn´t get it working yet and I didn´t find any reference to that problem in the help or the forum. Could anyone help me?

Thank you in advance,

r4zoli · Posted: Wed Aug 27, 2008 11:01 pm Post subject:

Before printing if you see red arrow, change report to edit mode. You can resize table row, until your text fit into cell, save changes, and print,

PS. Report is a document where all data inserted into table cells.

M3H0 · Posted: Thu Aug 28, 2008 12:26 am Post subject:

Hi,

At first thanks for your reply. I have tryed to do what you told me and it is a solution, but it is not what I'm looking for.

If I make the field box bigger, the whole text will have enough space as to appear in the report, but then, in the cases where text is shorter a lot of blank space will appear between the different articles of the report.

What I´m looking for is that the size of the field box will change dinamically for each article as it would occupy less space and the use of paper needed to print the report will be more efficient.

However, thank you a lot for your reply Very Happy

r4zoli · Posted: Thu Aug 28, 2008 10:33 pm Post subject:

If you see for SRB planned features it is a last point in list, and only first two will be developed until 3.0 with SRB 1.0.5.
This means that required feature will be in OOo, but not in near future.

M3H0 · Posted: Thu Aug 28, 2008 11:58 pm Post subject:

OK, so I suppose I will have to wait for a while to do it.

Thank you a lot for your help one more time.