StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20141363
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2013-11-22T09:31:18.990
FavoriteCount
0
LastActivityDate
2014-02-07T22:03:40.250
LastEditDate
2017-05-23T12:32:29.317
LastEditorUserId
-1
OwnerUserId
1915920
ParentId
2314780
PostTypeId
2
Score
7
ViewCount
0
LastEditorDisplayName
text
Body
There may be much easier and straight forward solutions: I am using Jasper Reports Studio (Eclipse Plugin). <ol> <li>did not finally work for me :-( ... (see 1. comment below my answer - may be a bug) you just can check [x] Data Pre Sorted in the Crosstab Properties. Of course this only works if you do not need another ordering somewhere else in the report based on the pre-sorted result set.</li> <li>using an invisible crosstab group header, which is rather tricky: <ol> <li>create a new row/column group (e.g. via Outline view), leave the initial name <code>Row Group1</code> or similar as is for now</li> <li>set its <code>Total Position</code> to <code>None</code> (we do not want to have a total column per row/column generated)</li> <li>move the group in the XML before the old one</li> <li>rename the group to some speaking name, e.g. <code>name="invisible sort column ..."</code> <ul> <li>(no further references to this group should exist in the XML anymore)</li> </ul></li> <li>if you are using group totals on your group (<code>Total Position</code> != <code>None</code>) then you have to basically move these totalling elements/settings to the first dummy sort group, because otherwise the totals will be no totals anymore (= per 2nd group totals) displayed after each group column/row, e.g. (here only shown with column group, but row group follows the same principle) <pre><code>a|b|c|sum a|sum|b|sum|c|sum ========= => ================= 1|2|3|6 1|1 |2|2 |3|3 </code></pre> <ul> <li>easiest may be to do this in the XML similar to this transformation (do not forget to move the <code>totalPosition=...</code> and <code>columnTotalGroup=...</code> attributes and to change the sum if applicable to your scenario <code>$V{SomeSum_..._ALL}</code>): <pre><code>... <columnGroup name="OrderXDummy" height="0"> ... <crosstabTotalColumnHeader> <cellContents/> </crosstabTotalColumnHeader> </columnGroup> ... <columnGroup name="X" ... totalPosition="End"> ... <crosstabTotalColumnHeader> <cellContents ...> ... </cellContents> </crosstabTotalColumnHeader> </columnGroup> ... <crosstabCell ... columnTotalGroup="X"> ... <textFieldExpression><![CDATA[$V{SomeSum_X_ALL}]]></textFieldExpression> ... </crosstabCell> </code></pre> => <pre><code>... <columnGroup name="OrderXDummy" height="0" totalPosition="End"> ... <crosstabTotalColumnHeader> <cellContents ...> ... </cellContents> </crosstabTotalColumnHeader> </columnGroup> ... <columnGroup name="X" ... > ... <crosstabTotalColumnHeader> <cellContents/> </crosstabTotalColumnHeader> ... </columnGroup> ... <crosstabCell ... columnTotalGroup="OrderXDummy"> ... <textFieldExpression><![CDATA[$V{SomeSum_OrderXDummy_ALL}]]></textFieldExpression> ... </crosstabCell> </code></pre></li> </ul></li> <li>(may be skipped:) remove unnecessarily generated <code><crosstabCell ... column/rowTotalGroup="..."></code> cells <ul> <li>its maybe best to compare the report with a previous version to reliably and fast identify these spots in the XML</li> <li>maybe this is not a crucial step, but looking at the existing XML is confusing enough ;-)</li> </ul></li> <li>add the (bucket) expression of your sort column, e.g. <code>$F{ORDER_FOR_X}</code> <ul> <li>don't forget to assign <code>Value Class Name</code> to <code>java.lang.Integer</code> or whatever fits for your values here (have a look at your dataset which type is assigned there if your are using it via some column)</li> </ul></li> <li>add some variable expression to the <code>Order By Expression</code> of the original group, e.g. <code>$V{ORDER_FOR_X}</code> <ul> <li><code>$V{...}</code> is the trick, do not use <code>$F{...}</code>!</li> <li>(the editor says it's invalid, but it will work)</li> <li>meaning if you can provide some field that defines the sort and relates to your to-be-sorted column value, e.g. (Oracle SQL) <pre><code>select 1 as order_for_x, 'foo' as x, 'bla blu' as y from dual union all select 2, 'bar', 'ta tu' from dual union all select 2, 'bar', 'na na' from dual union all select 1, 'foo', 'check it' from dual union all select 3, 'queue', 'sap' from dual </code></pre></li> <li>otherwise you can of course use something else here as well</li> <li>if you should get some <pre><code>... Caused by: java.lang.NullPointerException at org.apache.commons.collections.comparators.ComparableComparator.compare(ComparableComparator.java:92) at net.sf.jasperreports.crosstabs.fill.BucketExpressionOrderer.compareOrderValues(BucketExpressionOrderer.java:70) ... </code></pre> you can simply change the expression to <code>$V{ORDER_FOR_X} == null ? 0 : $V{ORDER_FOR_X}</code> which should do the trick</li> </ul></li> <li>set all high/width fields of the dummy group to <code>0</code> and the text fields <code>Print When Expression</code> to <code>false</code></li> <li>(maybe check via compare with the previous report version that nothing else has changed to make sure you didn't mess up something else)</li> </ol></li> <li>using an order by based on measure totals (as described in the bottom link)</li> <li>using a custom Java Comparator class (as described in the answer from <a href="https://stackoverflow.com/a/8153225/1915920">Pieter VN 2011-11-16</a>)</li> </ol> further maybe helpful links I found: <ul> <li><a href="http://community.jaspersoft.com/wiki/custom-crosstab-ordering-ireport-designer" rel="nofollow noreferrer">http://community.jaspersoft.com/wiki/custom-crosstab-ordering-ireport-designer</a></li> <li><a href="http://community.jaspersoft.com/questions/506284/combined-crosstabs" rel="nofollow noreferrer">http://community.jaspersoft.com/questions/506284/combined-crosstabs</a></li> <li><a href="http://jasperreports.sourceforge.net/schema.reference.html" rel="nofollow noreferrer">http://jasperreports.sourceforge.net/schema.reference.html</a></li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POJasper Reports crosstab sorting with comparatorExpression
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USAndreas Dietrich
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COusing solution 1. worked (maybe as long as I did not reopen the report in the designer?). I now have the problem, that it worked in the beginning, but now the aggregation is broken (may likely be a bug). The result is, that the detail data is only correct for the last column, the other details are 0 (based on some 'sum(numberval)' evaluation) and the amount of displayed rows equals the amount of [column count x row count]. disabling "[ ] Data Pre Sorted" works fine in my current case since right now I do not depend on this, but will in another scenario. :-(
 singulars
 PostPostId
 PO
 UserUserId
 USAndreas Dietrich

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.