remmy412

The report is completely done except this one issue, and I'm not using the ad hoc editor. Also, filtering is no good. The reason the row is in the report is b/c I left join with another table in order to get around another issue where there are "holes" in the columns. So if the row I don't want printed is filtered out, I'm back to square 1 with "holes" in the columns again. I can't believe I'm the first person to have this issue.

Never any resolution to this?

I have a crosstab where I want to hide (not just print blanks) a row, I don't want there to be any empty space where this row would be (like having a height of zero). In the crosstab there are "holes" in the data, so some columns don't show up, but the crosstabs are in the detail section and they need to line up with each other on a page, so even if there is no values in a column, that column still needs to be there. To get around this I redid the query with a left join, but the side effect is a "null" row. If there's a better way to solve the original problem so that the "null" row doesn't show up, I'd be up for that too!

Found a way to make it work: <bucketExpression class="com.yestern.jasper.support.RowWrapper"><![CDATA[new com.yestern.jasper.support.RowWrapper($F{TimePeriodName}.toString(), $F{PeriodSequence}.intValue())]]></bucketExpression> I don't know nearly enough to explain why it works, it just does. I got the idea to use this pattern from this thread: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=7449 It's the second option explained.

I'm trying to use the "wrapper" pattern in order to sort rows in a crosstab. My bucketExpression is: <bucketExpression class="com.yestern.jasper.support.RowWrapper"><![CDATA[new com.yestern.jasper.support.RowWrapper($F{TimePeriodName}, $F{PeriodSequence})]]></bucketExpression> RowWrapper checks the two args for null: public RowWrapper(String label, Integer order) { if (label == null) { throw new IllegalArgumentException("label must not be null"); } if (order == null) { throw new IllegalAccessError("order must not be null"); } this.label = label; this.order = order; } Running this report results in: java.lang.IllegalArgumentException: label must not be null Now, if I uset a bucketExpression of: <bucketExpression><![CDATA[$F{TimePeriodName}]]></bucketExpression> or <bucketExpression><![CDATA[$F{PeriodSequence}]]></bucketExpression> The report runs fine. Thoughts? P.S. I've also tried the bucketExpressions of (not that it should make a difference) and got the same "label must not be null" error: <bucketExpression class="com.yestern.jasper.support.RowWrapper">new com.yestern.jasper.support.RowWrapper($F{TimePeriodName}, $F{PeriodSequence})></bucketExpression>

I have a crosstab in a report. I need to keep the outermost rowgroup from splitting (keep the group together). Is there any way to do this? For Example, I need to go from this (------ is a page break) outerRowGroup innerRowGroup1 val1 val2 val3 Total innerRowGroup2 val4 val5 val6 Total ----------------------------------------------------------------------------------------- innerRowGroup3 val7 val9 val9 Total To this: ----------------------------------------------------------------------------------------- outerRowGroup innerRowGroup1 val1 val2 val3 Total innerRowGroup2 val4 val5 val6 Total innerRowGroup3 val7 val9 val9 Total