comparatorExpression cannot find field

[sravyts]

Hello,

 

I'm using a crosstab with a subdataset which contains a field called "ReportResult.modificationDate" which is of a custom class TimeStamp.

In my rowGroup I define the bucket as follows:

 

<bucket order="Descending">

<bucketExpression class="java.lang.String">

<![CDATA[$F{ReportResult.primaryKey}]]>

</bucketExpression>

<comparatorExpression>

<![CDATA[((Date)$F{ReportResult.modificationDate}.getJDKDate())]]>

</comparatorExpression>

</bucket>

 

getJDKDate() returns a java.util.Date which implements the Comparable interface.

 

But I always get the exception that the field ReportResult.modificationField cannot be found.

 

 

If I put this field in the bucketExpression for testing purpose, (and remove the comparatorExpression element) then it works ok (no errors).

 

If I define the field in my main dataset it works ok as well.

 

Can anyone help me with this one?

 

Wkr,

Sofie

[lucianc]

comparatorExpression is evaluated once per crosstab instance, and the evaluation happens in the report context (and not in the subdataset context). This expression must evaluate to a java.util.Comparator (and not Comparable). The comparator is used to order bucket values.

 

If you want to order the group buckets by modificationDate (assuming that such an order would make sense), you can follow the method described here.

 

HTH,

Lucian