java - how to sort columns in ireport crosstab in a specific scheme -


the following image shows crosstab in ireport:

crosstab

i want sort columns in specific order, knowing in crosstab data, put list of objects list<champetatateliers> following attributes :

public class champetatateliers {      private string numero;     private string denominationfr;     private string etatentreesortie;      public champetatateliers(string numero, string denominationfr, string etatentreesortie) {         this.numero = numero;         this.denominationfr = denominationfr;         this.etatentreesortie = etatentreesortie;     } }

the etatentreesortie shown in columns, denominationfr shown in rows, , numero used count in crosstab

string rapportlien = "/situationequipement.jasper"; map parametres = new hashmap(); jrbeancollectiondatasource data = new jrbeancollectiondatasource(atelierses);

in java i'm putting these objects in list atelierses list<champetatateliers>, there way sort columns in list or in crosstab ireport, xml code on ireport follows:

<columngroup name="nbrevehicule" height="66">     <bucket order="descending" class="java.lang.string">         <bucketexpression><![cdata[$f{nbrevehicule}]]></bucketexpression>         <orderbyexpression><![cdata[$v{myorderbyfield_measure}]]></orderbyexpression>     </bucket>     <crosstabcolumnheader>         <cellcontents backcolor="#f0f8ff" mode="opaque">             <textfield>                 <reportelement style="crosstab data text" x="0" y="0" width="85" height="66" uuid="2109b261-1b20-493a-b664-ce59731c4a20"/>                 <box toppadding="1" leftpadding="1" bottompadding="1" rightpadding="1"/>                 <textelement>                     <font isbold="true"/>                 </textelement>                 <textfieldexpression><![cdata[$v{nbrevehicule}]]></textfieldexpression>             </textfield>         </cellcontents>     </crosstabcolumnheader>     <crosstabtotalcolumnheader>         <cellcontents/>     </crosstabtotalcolumnheader> </columngroup> <measure name="myorderbyfield_measure" class="java.lang.integer"  calculation="nothing" >     <measureexpression><![cdata[$f{myorderbyfield}]]></measureexpression> </measure>

in jasper report crosstab columngroup can sorted ascending or descending setting order attribute on bucket

example

<columngroup name="group" height="16" headerposition="center">     <bucket order="descending" class="java.lang.string">         <bucketexpression><![cdata[$f{myfield}]]></bucketexpression>     </bucket>     ..... </columngroup>

if need user defined order, should use orderbyexpression

  1. define measure on order

    <measure name="myorderbyfield_measure" class="java.lang.integer" calculation="first">     <measureexpression><![cdata[$f{myorderbyfield}]]></measureexpression> </measure>

  2. use measure in orderbyexpression

    <columngroup name="group" height="16" headerposition="center">   <bucket class="java.lang.string">     <bucketexpression><![cdata[$f{myfield}]]></bucketexpression>     <orderbyexpression><![cdata[$v{myorderbyfield_measure}]]></orderbyexpression> </bucket> ..... </columngroup>

in example achieved introducing new field in champetatateliers class example private int myorderbyfield; , via code setting needed.

another solution, return own object (class) myfield , implement comparable, generates desired order.

edit: work around, op can not make orderbyexpression work correctly.

since myorderbyfield unique (related 1 1) nbrevehicule can use myorderbyfield in bucketexpression

<measure name="nbrevehicule_measure" class="java.lang.string">    <measureexpression><![cdata[$f{nbrevehicule}]]></measureexpression> </measure>  <columngroup name="nbrevehicule" height="66">    <bucket class="java.lang.integer">      <bucketexpression><![cdata[$f{myorderbyfield}]]></bucketexpression>    </bucket>    ....    <textfieldexpression><![cdata[$v{nbrevehicule_measure}]]></textfieldexpression>    ..... </columngroup>

hence bucketexpression not need same text displayed in crosstabcolumnheader


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

ruby on rails - Seeing duplicate requests handled with Unicorn -

recently upgraded our ec2 instances c3.large in order boost more unicorn workers handle increased traffic our site. (6xworkers per machine - 2 ec2 instances). when did this, started seeing duplicate records being created! looks somehow, maybe 2 unicorn workers attempting process same request? in nginx logs see 1 [post] request particular rails controller - yet 2 records being created in database. i'm hitting kind of race condition issue - have no idea how debug this. doesn't happen time, when it's frustrating well. noticed 2 database records within 5 seconds of each other. (and yes disable button when user clicks submit button). unicorn 4.8.2 ruby 1.9.3 rails 3.2.14 any great! thanks! although may not fix problem, upgrade ruby 2.0.0. there blog mentioning idea upgrade ruby 2.0.0 if using unicorn. for example: https://www.digitalocean.com/community/articles/how-to-optimize-unicorn-workers-in-a-ruby-on-rails-app specifically: if using ruby 1.9, ...
Read more