[cell splitting]

Hi,

 I have an excel formatted report.  It works fine except when the contents of the cell is larger than I had allocated.  What happens is it wraps the text which increases the cell height.  The other cells in the same row, however, do not increase in height but instead split into another cell.  How can this problem be fixed?

Thanks

btw, I'm using jasperreports v2 but am fine to upgrade to v3 if need be.

[cell splitting in xls]

Thanks anandharaj,

 

When you say to make sure they are on the same axis, if I call a subreport for say x=300, y=0, width=100. In the subreport, I have specified x=0,y=0, width=100. I figured the axis is relative to the start yes?

 

I have already disabled the splitting. Should the stretch options be to tallest object or band height?

[cell splitting in xls]

I have a problem where 2 column cells will split when another column in the row wraps.

 

size=294]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/extrarow-3fa7c9ebc0ba7bc8cb7140fd4d28da40.GIF

 

I have 4 report templates for this report.

 

rp1: high level, labels column headers

rp2: has details section for all but 2 columns, calls subreports 2a and 2b for them.

 

rp2a: fills in details for just one column

rp2b: fills in details for just one column

 

I rp2a and 2b, I have split set to false for the textfield as well as the stretch to band height option.

 

I did the same for the subreport calls from rp2. Still no improvement, any ideas what I'm missing?

 

Attaching report files

 

rp2a

[file name=TestPlan_ResultDetails_DEVICENAME.jrxml size=3793]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/TestPlan_ResultDetails_DEVICENAME.jrxml[/file]

[XLS format creates extra row if large value]

What you suggest makes sense but I'm still not having much luck.

 

I only have the splitting problem for the 2 columns that are called via additional subreports.

 

There are essentially 4 reports in all

 

rp1 (shows column headers, and calls subreport for rp2)

rp2 (has details for all columns except 2, calls 2 subreports [rp3a,rp3b] to supply values for 2 columns)

rp3a

rp3b

 

so in rp3a,rp3b I have

-split not allowed on band

-'Relative to band height' for the one textfield' (one textfield per report)

 

in rp2, I have

-split not allowed on band

-the subreport calls have 'Relative to band height' for the 2 columns

 

What am I missing?

Thanks

[XLS format creates extra row if large value]

Thanks, I figured out the extra column problem with your suggestions. It turned out that my subreport width parameter was much less than the report pageWidth. When I made them the same, the column disappeared.

 

I'm still having a problem with an extra cell created below the value when a neighboring column wraps. It's easier to explain if you look at the image. I know I can truncate the value in the other cell but isn't there a way to allow the first column (see example) to stretch and be the same height? I should also mention that in this particular example, the first row is itself a subreport below that of the other columns.

size=294]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/extrarow.GIF

Post edited by: dtrobert, at: 2007/05/15 21:23

[XLS format creates extra row if large value]

Okay, very confused now but getting closer.

 

1. I reduce the number of columns to end with the first column showing this behavior.

 

2. I switched data in the columns, copied formatting from other columns, etc. The result being that now, the last column of the report has this extra 'tiny column'.

 

I then played with column count, page width but nothing helped. It's not the data in the column since switching it works fine (column looks good in new location). There's nothing different about the column definition itself (textField stuff). It almost seems like a weird bug but I can't even give a reason for it to occur.

[XLS format creates extra row if large value]

It's actually very odd since, although there are 2 columns in Excel, it's like the first (column header row) is a merged cell still. Click on it selects the value across both Excel columns.

[XLS format creates extra row if large value]

Changed the 'isStretchWithOverflow="false" (was true) for both column header and detail sections but no difference. Attaching what I mean by extra column. size=294]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/extracolumn.GIF

 

Thanks

[XLS format creates extra row if large value]

Here's an excerpt from the report...

 

<jasperReport

name="MyReport"

columnCount="1"

printOrder="Vertical"

orientation="Landscape"

pageWidth="6600"

pageHeight="30"

columnWidth="6600"

columnSpacing="0"

leftMargin="0"

 

----------cut-----------------------------

 

<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="700"

y="0"

width="100"

height="15"

key="Description"

stretchType="RelativeToTallestObject"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement>

<font reportFont="Verdana_Bold" pdfFontName="Helvetica"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Description"]]></textFieldExpression>

</textField>

[XLS format creates extra row if large value]

Thanks for the info,

I have isStretchWithOverflow="true" and stretchType="RelativeToTallestObject" . The problem isn't the text hanging over because it's wrapping. The problem is that I'm seeing extra blank columns added after columns where the values_maxwidth > field_maxwidth. I'm not really sure why it's happening or if it should.

 

One thing is that I'm using columns and column width=100. However, I've had to override some columns to be larger than 100--not sure if that might be causing the problem.

[XLS format creates extra row if large value]

Hi,

I have a report that produces a standard XLS output. It works well except when the value in the cell exceeds that defined by the width. In that case, the report ends up creating extra rows beneath the large cell. Is there a setting to either expand the field width to adjust automatically to the largest value (i.e. auto-fit column) or truncate it?

 

Thanks

[subreport report properties]

hi, I'm a Jasper newby

I'm trying to create a graphical report which includes several subreports. The main template report properties are set for Letter portrait with no margins. The first subreport contains two frames designed to take up half of the width side by side in the report. I'm having all sorts of formatting problems where some frames (graphs) don't display at all in html, but do in pdf--format still messed up.

 

My question is, what's the rule for the report properties of subreports. Should the dimensions be the same as the top level template or just the absolute size it is expected to take.