开发者

Displaytag footer average

开发者 https://www.devze.com 2023-03-25 14:58 出处:网络
Im using displaytag to create reports. In the footer of the reporti would like to show the average sum of a couple of my columns. Average sum of \"pris\" and \"dekningsprosent\".

Im using displaytag to create reports. In the footer of the report i would like to show the average sum of a couple of my columns. Average sum of "pris" and "dekningsprosent".

Is this possible with displaytag? I have seen there is a method for counting totals, but i cant find for average.

Hope you guys can help! Here is my code so far:

<display:table name="rapportList" class="tab开发者_运维百科le" requestURI="" id="rapportList" export="true" pagesize="25">

<display:column property="leilighetId" sortable="true" titleKey="report.header.leilighetId"/>
<display:column property="pris" sortable="true" titleKey="report.header.price" format="{0,number,currency}"/>
<display:column property="dekningProsent" sortable="true" titleKey="report.header.coverage" format="{0,number,percent}"/>

<display:footer>
  //What goes in here to get the average?
</display:footer>
</display>

Thanks in advance!


Try this:

in your displayTag declarations, you put the varTotals properties:

<display:table name="rapportList" class="table" requestURI="" id="rapportList" export="true" pagesize="25"  varTotals="myTotalValue">

and after that you must in each column you want to sum the property total="true" :

<display:column property="pris" sortable="true" titleKey="report.header.price" format="{0,number,currency}"/>

the last step is make your footer receive the sum calculations, like:

    <display:footer>
   <td>${myTotalValue.column2}</td>
</display:footer>

Don't forget that the number of the columns in this case starts with one, and not zero like the arrays patterns

0

精彩评论

暂无评论...
验证码 换一张
取 消