Comparator expression on crosstab ??

[jbo_master]

hello all,

Is it right that we can override the sorting order of a row or column group of a crosstab by a comparator expression?

If we can,
does anyone of you guys have an working example of such a "comparator expression"?

Thanks for your help


 

 

[hq4ever]

This is 1:1 my problem.

 

I would love to hear someone with a working example

[dfreis]

had exactly the same problem.

Found a 'quite hacky' solution using a Comparator and an Object[] as expression (see code)

and use:

"((Object[])$V{"+nameOfYourRowGroup+"})[0]"

as the expression text of your header Cell.

hope you got the idea,

regards

Dieter

 

Code:

JRDesignCrosstabBucket bucket = new JRDesignCrosstabBucket();JRDesignExpression orderComparator = new JRDesignExpression();orderComparator.setValueClass(Comparator.class);orderComparator.setText("$P{Comparator}.getComparator()"); // or new MyComparator() ...bucket.setComparatorExpression(orderComparator);rowExpression.setText("new Object[] {$F{"+yourValueToDisplay+"}, $F{"+yourValueToOrder+"}}");rowExpression.setValueClass(Object.class);