Jump to content
  • Sort/Order CrossTabData columns


    bibinjacob
    Assigned User lucianc
    CategoryFeature request
    PriorityUrgent
    ReproducibilityAlways
    ResolutionFixed
    SeverityCritical
    StatusClosed

    Will i be able to order/sort crosstab data as mentioned below .

    I have NAMEas row group and STATUS as column group.

    Again Vol and Sum are static texts added.

    Value of Vol and Sum corresponds to 2 measures defined.

    ------------------------------------|

    STATUS--------------->| status1 |

    NAME-------------------|Vol|Sum|

    A................................2...100

    B................................1....50

    C................................4....34

    I can sort on NAME and STATUS

    What is required is ---I want to sort on Vol and/or Sum.

    See the required result below.

    ------------------------------------|

    STATUS--------------->| status1 |

    NAME--------------------|Vol|Sum|

    B.................................1....50

    A.................................2...100

    C.................................4....34

     



    User Feedback

    Recommended Comments

    Implemented in the JR SVN trunk (to be included in the upcoming 3.6.2 release).

     

    Sorting a crosstab group is done by including an in the group bucket. The expression can use crosstab measure variables, which evaluate to the group totals. See demo/samples/crosstab/OrdersReport.jrxml for a working example.

     

    SVN log:

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/JRCrosstabBucket.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/base/JRBaseCrosstabBucket.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/design/JRDesignCrosstabBucket.java

    Adding /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/fill/calculation/ArbitraryRankComparator.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/fill/calculation/BucketDefinition.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/fill/calculation/BucketingService.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/crosstabs/xml/JRCrosstabBucketFactory.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/JRExpressionCollector.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/design/JRVerifier.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/dtds/jasperreport.xsd

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/fill/JRFillCrosstab.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/xml/JRExpressionFactory.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/xml/JRXmlDigesterFactory.java

    Sending /home/lucian/lucru/jasperreports/src/net/sf/jasperreports/engine/xml/JRXmlWriter.java

    Transmitting file data ...

    Committed revision 3203.

     

     

    Link to comment
    Share on other sites


×
×
  • Create New...