Jump to content
We've recently updated our Privacy Statement, available here ×

kolaitis

Members
  • Posts

    35
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by kolaitis

  1. Try to use iReport variable PAGE_NUMBER. PrintWhenExpression : new Boolean($V{PAGE_NUMBER}.intValue()== int)
  2. Suggestion only for lowerCase / upperCase. Create var : V1, classType: java.lang.Character, expression: new Character(yourFildName.chartAt(7)) Create another var : V2, classType: java.lang.String, expression: $V{V1}.toString().equalsIgnoreCase("X") ? {yourFildName}.toLowerCase() : {yourFildName}.toUpperCase() drag V2 on your band. Mind Eval. time ! For Mid print, create field using smaller fonts with printWhenExpression. I hope it will works...
  3. Create dummy report Groups as many as you need. Plenty space on header, footer. If you use charts, use subdatasets ( save run time).
  4. printWhenExpression new Boolean(your criteria)
  5. please try: - Create on detail band one subreport selecting FistName, Lastname ect. query : select * from (yourFile) where yourFile.Level = $P{P_LEVEL} - Assign subreport param : P_LEVEL type : what it is ? - Copy 3 times the created subreport on detail band as follow |_____________________| printWithExpression : new Boolean($F{Level}.intValue() = 1) |______________________| printWithExpression : new Boolean($F{Level}.intValue() = 2) |_______________________| printWithExpression : new Boolean($F{Level}.intValue() = 3) for each subreport in properties : Remove line when blank : TRUE - On main report for each subreport right click and add subreport Parameter : LEVEL expression: $F{Level} - On main report add parameter : SUBREPORT_DIR default value expression : "./" Good Luck.
  6. try this.... Assign variable TOTAL_VALUE with appropriate expression Assign variable VALUE -""- -""- -""- Reset Type: Group (your GroupName). Drag variable VALUE on (your GroupName) eval.Time : Group, eval.Group : your GroupName Create text field on (your GroupName) with expression : new Double(($V{VALUE}.doubleValue() / $V{TOTAL_VALUE}.doubleValue())*100) eval.Time : Auto. I hope it will works.
  7. My suggestion is move your fields from page footer on the Summary Band
  8. WHERE v.Licensee= $P{Licensee} AND DATE_FORMAT(v.Visit_date,'%Y-%m') IN ($P{months}) AND vb.Visit LIKE '%$!P{Visit}%' AND vb.Include_YN=True try this format : vb.Visit LIKE '%$P!{Visit}%'I hope it will works.
  9. I am using IReport V.2.0.5 . In my report I use : ColumnHeader for totals , DetailBand , ColumnFooter with floating TRUE for totals , SummaryBand with height : 490 , containing : text-fields , parameters , variables. How can I achieve to print SummaryBand after ColumnFooter while there is enough space to print in last page. I do not wish SummaryBand on new page. Thanking you for any answer.
×
×
  • Create New...