Hello Lucian, many thanks for your reply. It helped a lot and gives the key hints.
I've created a bean to support both problems; the order problem is solved and it also contains the data to be used in the headers. Regards, Christian Lucian Chirita wrote: > There are some discussions on the forum/mailing list regarding the use > of multiple values for a crosstab bucket (I guess that this is what you > need - to use a field for display and another to order). The engine > does not yet support this directly, but it's considered for future releases. > > A simple way to achieve the functionality is to create a bean that wraps > the multiple values and uses each of them for any purpose. The bean > would need to provide adequate implementation of equals(Object) and > hashCode() and implement Comparable. The bean type would then be used > as crosstab bucket values. > > Regarding your first question, fields from the crosstab subdataset are > not available in crosstab headers as a crosstab represents an aggregated > view of the subdataset, only aggregation criteria (bucket values) and > aggregated data (measures) are available. > > Regards, > Lucian > > > Christian Stuellenberg wrote: >> Hello, >> >> I've just started learning to work with crosstabs. >> >> I've got a few problems: >> >> I'm using several row and column groups; I would like to use some fields >> from the crosstabSubdataset in the column and row header, but that does not >> seem to work. >> >> I can work with bucket expression, but that only seems to declare a variable >> with the name of the bucket. Is it only possible to use this variable in >> the header? >> >> What I also would need, is a bucket that orders along to a field A from the >> subdataset, but I would like to "display" a corresponding field B in the >> header. >> >> Thanks in advance for any help, >> Christian >> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >> for problems? Stop! Download the new AJAX search engine that makes >> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >> _______________________________________________ >> jasperreports-questions mailing list >> jasperreports-questions@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions >> > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > jasperreports-questions mailing list > jasperreports-questions@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jasperreports-questions > > ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
