Eclipse Community Forums: BIRT » Wrap text in a cell

Help

Home

Home » Eclipse Projects » BIRT » Wrap text in a cell(Wrap text in a cell)

Show: Today's Messages :: Show Polls :: Message Navigator

Wrap text in a cell [message #736212]

Thu, 13 October 2011 16:11

Amitava
Messages: 15
Registered: September 2011

Junior Member

I have a report layout which contains a whole bunch of columns some of which might contain big data. As a result I need wrap text feature inside a cell but there is none in BIRT that I can find. I find BIRT is actually truncating the cell data.

Report message to a moderator

Re: Wrap text in a cell [message #736222 is a reply to message #736212]

Thu, 13 October 2011 16:37

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Can you try using a dynamic text element instead of a data item?

Jason

On 10/13/2011 4:11 PM, Amitava wrote:
> I have a report layout which contains a whole bunch of columns some of
> which might contain big data. As a result I need wrap text feature
> inside a cell but there is none in BIRT that I can find. I find BIRT is
> actually truncating the cell data.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #737135 is a reply to message #736222]

Fri, 14 October 2011 13:48

Amitava
Messages: 15
Registered: September 2011

Junior Member

No change; it is truncating both.

Report message to a moderator

Re: Wrap text in a cell [message #737145 is a reply to message #737135]

Fri, 14 October 2011 14:01

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Any way you can write a report that uses the sample db or a scripted
data set that shows the issue, that I can run?

Jason

On 10/14/2011 1:48 PM, Amitava wrote:
> No change; it is truncating both.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #739502 is a reply to message #737145]

Mon, 17 October 2011 10:44

Amitava
Messages: 15
Registered: September 2011

Junior Member

Please find attached the report file containing the columbs which may contain big data. The report uses Oracle 10g DB and sql to get the data. I'm not sure what do you want to re-create the scenario.Do you want the table desc also.

Attachment: AcctRep.rptdesign
(Size: 56.64KB, Downloaded 143 times)

Report message to a moderator

Re: Wrap text in a cell [message #739635 is a reply to message #739502]

Mon, 17 October 2011 13:22

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Which columns?

Jason

On 10/17/2011 10:44 AM, Amitava wrote:
> Please find attached the report file containing the columbs which may contain big data. The report uses Oracle 10g DB and sql to get the data. I'm not sure what do you want to re-create the scenario.Do you want the table desc also.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #739684 is a reply to message #739635]

Mon, 17 October 2011 14:42

Amitava
Messages: 15
Registered: September 2011

Junior Member

Sender Reference Number
Debit Business Unit Name
Credit Business Unit Name

Report message to a moderator

Re: Wrap text in a cell [message #739723 is a reply to message #739684]

Mon, 17 October 2011 15:40

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

None of those are dynamic text elements.

Jason

On 10/17/2011 2:42 PM, Amitava wrote:
> Sender Reference Number
> Debit Business Unit Name
> Credit Business Unit Name

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #739739 is a reply to message #739723]

Mon, 17 October 2011 16:06

Amitava
Messages: 15
Registered: September 2011

Junior Member

I mentioned earlier that changing them to dynamic text does not solve the issue of truncating really long text.

Report message to a moderator

Re: Wrap text in a cell [message #739784 is a reply to message #739739]

Mon, 17 October 2011 17:21

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Is there spaces in the text?

Jason

On 10/17/2011 4:06 PM, Amitava wrote:
> I mentioned earlier that changing them to dynamic text does not solve
> the issue of truncating really long text.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #740464 is a reply to message #739784]

Tue, 18 October 2011 10:40

Amitava
Messages: 15
Registered: September 2011

Junior Member

No; they are mostly system generated long reference numbers, names etc.

Report message to a moderator

Re: Wrap text in a cell [message #740650 is a reply to message #740464]

Tue, 18 October 2011 14:46

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Take a look at this thread:
http://www.birt-exchange.org/org/forum/index.php/topic/19827-how-do-i-use-word-wrap-in-report-design/page__s__173b4ad992e47395e2c8b9070c2d3cce

Jason

On 10/18/2011 10:40 AM, Amitava wrote:
> No; they are mostly system generated long reference numbers, names etc.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #740689 is a reply to message #740650]

Tue, 18 October 2011 15:40

Amitava
Messages: 15
Registered: September 2011

Junior Member

Thanks Jason. I found the wrap() function inside the thread you recommended. That solved the wrap issue.

Report message to a moderator

Re: Wrap text in a cell [message #900633 is a reply to message #740689]

Tue, 07 August 2012 17:17

Manikandan Krishnan is currently offline

Manikandan Krishnan
Messages: 2
Registered: August 2012

Junior Member

No need to write wrap() function. We have the properties available in Birt design template for wrapping the text.

1. Once you placed the dataset column element inside table / grid / cell. Select the dataset column element from table / grid and go to properties.
2. Under General pane in properties window, make sure it displays "Properties - Data" on that top. This is to make sure you are in dataset element properties.
3. Update "Whitespace" properties as "Auto". It will be there in General pane.
2. DO NOT go to table / grid properties.

Please refer the attachment.

Note: I have faced the same issue, "wrap text is not working in my excel". After 1 week, i found this option. Now word wrap is working fine.

Thanks,
Mani

Attachment: Birt.jpg
(Size: 83.29KB, Downloaded 225 times)

Report message to a moderator

Re: Wrap text in a cell [message #938683 is a reply to message #900633]

Wed, 10 October 2012 00:12

Jeff Stouse
Messages: 13
Registered: May 2012

Junior Member

Using BIRT Indigo 3.7.2

I have a table where I have dragged a data item from the Data Set list into a cell. The cell's properties (Whitespace) is set to Auto. Text will not wrap until I set the line height tall enough for the text (usually 3-4 lines deep, with each line having 3-4 words - column width is about 2")

I've tried placing the data as data and dynamic text -being sure to set the whitespace option to Auto, and the line height option (Advanced/Text) to Auto.

None of the above scenarios work, so I'm forced to have a lot of wasted whitepace in my report, especially when the data is only one word. Looks pretty bad.

I thought BIRT should do this (automatically increase the line height to accommodate the necessary number of lines when the wrap function dictates.) In my case, the wrap function works until the allocated line height is enough. If the line height is not enough to see all of the data, then whatever the line can display is the limit - all following data gets truncated.

Help!

Report message to a moderator

Re: Wrap text in a cell [message #939196 is a reply to message #938683]

Wed, 10 October 2012 10:14

Manikandan Krishnan
Messages: 2
Registered: August 2012

Junior Member

I understand your issue. You have 2 options.

Option 1: If you are using scripts in birt design template, you can process row data within scripts using the below example:

Example:
Script on row.onCreate:
if (this.getRowData().getExpressionValue("row[QtyOrdered]") > 30){
this.getStyle().fontFamily = "Arial"
this.getStyle().backgroundColor = "Yellow"
}

Note: This is just an example, please find out the properties for row height and increase the size if the data size is big.

Option 2: If you are using Java, please following the below step

RowEventAdapter in Java:

Example:
public class RowEH extends RowEventAdapter {
public void onCreate(IRowInstance row, IReportContext context) {
IRowData data = row.getRowData();
double avgCreditLimit = ((Double) row.getParent().getNamedExpressionValue("total_limit_avg")).doubleValue();
try
{
if (((Double) data.getExpressionValue("row[\"CREDITLIMIT\"]")).doubleValue() > avgCreditLimit ) {
row.getStyle( ).setFontWeight( "bolder" );
row.getStyle( ).setFontSize( "larger" );
row.getStyle( ).setColor( "olive" );
}
} catch (Exception e) {
e.printStackTrace();
}
}

}

Note: The above code is just an example. You have to find out the properties for increasing the ROW height using IRowInstance instance.
Check the length of the DATA, if it has more words, increase the row height using ROW instance.

Adding the event handler to the Report
You should add event handler by selecting the row and entering my.test.events.RowEH in the Event Handler entry on the Properties tab

REFER the below link for more examples on Event Handlers:
http://www.eclipse.org/birt/phoenix/deploy/reportScripting.php

Thanks,
Mani

Report message to a moderator

Re: Wrap text in a cell [message #958789 is a reply to message #938683]

Fri, 26 October 2012 04:04

Anna T.
Messages: 4
Registered: June 2012

Junior Member

Hi Jeff,

I am trying to set the line height option as you mentioned to Auto, but when I select a table row and go to Properties > Advanced > Text > Line Height I am only allowed to specify a measure. How can I specify that I want the height to be Auto?

Report message to a moderator

Re: Wrap text in a cell [message #959101 is a reply to message #958789]

Fri, 26 October 2012 09:01

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Anna

What are you trying to accomplish? If you want the row height to be auto clear the value and do not set it to anything.

Jason

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Wrap text in a cell [message #959143 is a reply to message #959101]

Fri, 26 October 2012 09:42

Anna T.
Messages: 4
Registered: June 2012

Junior Member

Well actually I have an issue when exporting my report to xls.

I have a table that has many columns. The text in the columns is quite big so it has to wrap in order to see everything.
The HTML, PDF and RTF exports look ok but in the excel export the row height is too small to accomodate the text so part of the text is not visible.

I thought maybe there is a property that I am not aware of.

Report message to a moderator

Re: Wrap text in a cell [message #986328 is a reply to message #939196]

Mon, 19 November 2012 21:32

Jeff Stouse
Messages: 13
Registered: May 2012

Junior Member

Mani,

You are talking to a complete rookie when it comes to scripting.

First of all, I cannot believe that BIRT FAILS to offer this functionality without resorting to writing an event handler. Why hasn't someone written a generic option that is a property for each cell in a table/grid?
As evidenced by the searches I spent hours going through, I am not the only one needing this functionality...

OK, so I have to write an event handler. Thanks for pointing me in that direction. I am reading the material that you linked to, but I have not a clue on how to calculate the need to increase the row height based on the amount of text left to display (I cannot figure out how to calculate that.) If I'm going to take the time to attempt this (no sleep tonight, or tomorrow, or the next night...) then shouldn't the plan be to create a script that looks at the size of the value to be displayed and then calculates how many rows (height of a standard row) it will need to display that amount of text, given the width of the cell?

Sign me,

Not a scripter (yet, apparently)

Thanks for your suggestions.

Report message to a moderator

Re: Wrap text in a cell [message #986563 is a reply to message #986328]

Tue, 20 November 2012 18:28

Michael Williams
Messages: 802
Registered: July 2009

Senior Member

Jeff,

Are you certain you don't have a height set on the actual grid or detail row that you're putting your text element into? It sounds to me that a value is set. If it is, BIRT will not expand or minimize that row to fit your data. Let me know.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:	how can i change y-axis
Next Topic:	Can't customize X axis scale

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 02:13:09 EDT 2013