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

andrew.wayman

Members
  • Posts

    2
  • Joined

  • Last visited

andrew.wayman's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Please can someone point me in the right direction i am at the end of my tether and getting nowhere fast !! I am endevouring to generate a selection based query and parse these parameters via jasperstarter as a command line. i am reporting on a transaction table that has multiple selecetions and hence the where clause is becomming a little more complex, it is working to a point but when i add a parameter that is a coma separated list e.g account numbers "1001","1004","1005" etc my report fails. I have the following where clause: $X{BETWEEN,table_name.trans_date,v_date_from,v_date_to} // this works fine (When the following line is added it goes wrong) AND $X{IN,table_name.idcustomer, v_customer} the v_customer parameter i have tried using the class types of both java.util.list and java.util.collection but neither seems to work. The parameter v_customer contains a "1001","1004" etc list. Please can someone hlep, i am really lost as to where i am going wrong. It works fine in Jasper Studio, but when parsing the parameters from Jasperstarter command line it fails with the following error Parameter 'v_customer' of type 'java.util.Collection with value '1001','1004','1005' is not supported by JasperStarter! Thanks in advance
  2. I would be most grateful if someone could help me out or point me in the right direction. I am a newbie to Jasper Reports. I am using a mysql database where i have a integer field with values of 1 - 10. When generating my iReport in iReport Designer i need to substitute the int value for a string value e.g. 1="Consultancy" 2="Maintenance" , 3="Support" 4= "Pre-Sales" etc etc. I can do this using the $F{Var}.IntValue() == 1 ? "Consultancy" : "Maintenance" but this is Boolean and only two values are permitted, I am really struggling to fathom how to resolve this issue to alliow multiple values. Please could someone assist Thanks
×
×
  • Create New...