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

gio.jamburia

Members
  • Posts

    3
  • 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 gio.jamburia

  1. I'm trying to configure variable expression in ireport , I want to write function to calculate 2 things Gross and Net TEU . Variable 1 (Gross) For Gross I have two parameters Dwell Days and Equipment ISO Group. I trying to get sum of this two things , if Equipment ISO Group value starts with 2 ( Dwell Days + 1) * 1 and if Equipment ISO Group value starts with 4 ( Dwell Days + 1) * 2 . I need sum of this two IF's . I wrote expression but it's not correct : ($F{EquipmentISOGroup} = 2*? $F{DwellDays}+1)+($F{EquipmentISOGroup} = 4*? ($F{DwellDays}+1)*2) Variable 2 (Net) For Net I have 3 parameters Freight Kind, Dwell Days and Equipment ISO Group. If Freight Kind is "FCL" and if Equipment ISO Group value starts with 2 ( Dwell Days -1) * 1 and if Equipment ISO Group value starts with 4 ( Dwell Days -1) * 2 it's for FCL. If Freight Kind is "Empty" and if Equipment ISO Group value starts with 2 ( Dwell Days -4) * 1 and if Equipment ISO Group value starts with 4 ( Dwell Days -4) * 2 Its for Empty. ($F{FreightKind} = "FCL"? ($F{EquipmentISOGroup} = 2*? $F{DwellDays}-1)+($F{EquipmentISOGroup} = 4*? ($F{DwellDays}-1)*2))+($F{FreightKind} = "Empty"? ($F{EquipmentISOGroup} = 2*? $F{DwellDays}-4)+($F{EquipmentISOGroup} = 4*? ($F{DwellDays}-4)*2)) Please help to write right variable expression.
  2. In my report design I have one detail in detail 1 gap and I also put one addition detail in summery. When i import my report design to Billing APP and generate the invoice it fills all detail 1 data for all items (it makes list) and the detail which is in the summery is filled only with data of the last item from detail 1. how to make Billing APP fill date for all items in detail (in summery)? I also tried to move details together like band 1 - detail 1 and band 2 - detail 2 but it makes mix of data - first detail with first item's data second detail with first item's data and like this for all the items . All in all i want to group items data by details , first detail and all items with its data and in summery second detail with all items data. In my Billing APP subreports , tables doesnt work )))).
  3. In my report i have 2 details on is chart and second is table. when i push my report design to the software and run the report it fills first detail with all parameters and then fills the table (deail2) then again for all the new items detail 1 + detail 2 ,but i want to separate details . I want that report should fill detail 1 with all parametes for all items and then fill all tables this details should not be mixed. Also there is another way i tried i put the deatil 2 (table ) in the summery and the first detail worked it gave all items listed and in the summery there was only one table filled with information of the last item from detail 1 . how to fix it for all the items from deail one that there will be tables for all the items from detail 1.
×
×
  • Create New...