jasper reports - How to align total fields in column footer? -


i have created report in jasper ireport. alignment of fields in not appropriate want.

i have added date , sms count in detail band , total sms count in column band. when have total sms count in detail band iterate , show multiple time.

sms count report image:

sms count report image

xml code ... 

  <?xml version="1.0" encoding="utf-8"?> <jasperreport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="smscount" pagewidth="595" pageheight="842" columnwidth="555" leftmargin="20" rightmargin="20" topmargin="20" bottommargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="subreport_dir" class="java.lang.string" isforprompting="false">     <defaultvalueexpression><![cdata["c:\\users\\nic\\desktop\\report\\"]]></defaultvalueexpression> </parameter> <parameter name="fromdate" class="java.util.date"/> <parameter name="todate" class="java.util.date"/> <querystring>     <![cdata[select (select sum(sent_count) immigration.overstay_sent_sms_count  sent_date between $p{fromdate} , $p{todate}) totalcount,to_char(sent_date,'dd-mm-yyyy') sent_date,sent_count immigration.overstay_sent_sms_count sent_date between $p{fromdate} , $p{todate}]]> </querystring> <field name="totalcount" class="java.math.bigdecimal"/> <field name="sent_date" class="java.lang.string"/> <field name="sent_count" class="java.math.bigdecimal"/> <background>     <band splittype="stretch"/> </background> <title>     <band height="83" splittype="stretch">         <statictext>             <reportelement x="122" y="21" width="420" height="48" forecolor="#ff9999"/>             <textelement>                 <font size="30"/>             </textelement>             <text><![cdata[national informatic center]]></text>         </statictext>     </band> </title> <pageheader>     <band height="35" splittype="stretch">         <statictext>             <reportelement x="234" y="0" width="139" height="24"/>             <textelement>                 <font size="14" isunderline="true"/>             </textelement>             <text><![cdata[sms count reports]]></text>         </statictext>     </band> </pageheader> <columnheader>     <band height="28" splittype="stretch">         <statictext>             <reportelement mode="transparent" x="61" y="0" width="100" height="20" backcolor="#cccccc"/>             <textelement textalignment="center">                 <font size="12"/>             </textelement>             <text><![cdata[date]]></text>         </statictext>         <statictext>             <reportelement x="404" y="0" width="100" height="20" backcolor="#cccccc"/>             <textelement textalignment="center">                 <font size="12"/>             </textelement>             <text><![cdata[sms count]]></text>         </statictext>     </band> </columnheader> <detail>     <band height="35" splittype="stretch">         <textfield>             <reportelement x="61" y="9" width="100" height="20" backcolor="#ffffff"/>             <textelement textalignment="center"/>             <textfieldexpression><![cdata[$f{sent_date}]]></textfieldexpression>         </textfield>         <textfield>             <reportelement x="404" y="9" width="100" height="20"/>             <textelement textalignment="center"/>             <textfieldexpression><![cdata[$f{sent_count}]]></textfieldexpression>         </textfield>     </band> </detail> <columnfooter>     <band height="35">         <textfield>             <reportelement x="404" y="0" width="100" height="20"/>             <textelement textalignment="center"/>             <textfieldexpression><![cdata[$f{totalcount}]]></textfieldexpression>         </textfield>         <statictext>             <reportelement x="291" y="0" width="113" height="20"/>             <textelement>                 <font isitalic="true"/>             </textelement>             <text><![cdata[     total sms count=]]></text>         </statictext>     </band> </columnfooter>

activate "float column footer" in report properties.

ireport screenshot


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more