andrew.wayman
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by andrew.wayman
-
-
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
passing selection list as a $P or $X
in Products
Posted
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