coderb

Hi, I have an issue with the Scheduler on community version: 3.7.0. This works fine on installation of v.3.0.0 that I also have running. When editing a schedule I have a multi-select -query which I previously selected and saved multiple items from the list. However, these items are not automatically selected the next time I edit the schedule and pass that step. The report runs fine, so the parameters are still saved, but i think its only the web app that for some reason is not reselecting the selected items in the list. Has anyone else had this problem, or maybe you know how to help? thank you.

Hi all, I would like to have different sender email addresses for Reports being sent out on my single instance of JasperServer (community version). So, depending on which report gets sent out, it should have a specific sender email address. At the moment I have two completely different addresses, including the smtp host (domain name), so I assume I would have to somehow define multiple report.scheduler.mail.sender in ../WEB-INF/js.quartz.properties and then somehow link the sender to each report. I guess its not possible using one install of Jasperserver ? If not, is it easy enough to duplicate an Jasperserver install (as another webapp name) on the same machine. If this is the only option, I would simply copy the webapp as another name, create a duplicated mysqldb, and then change the new webbapp config to point to the new mysqldb and update the js.quartz.properties file. Would this be the main steps, or is it a lot more complex, as in I would need to do a full fresh install from the war file? thanks for any help

thanks Raj, appreciate the quick response and help

If you can get past all the typos, can anyone help me here? Please...

Hi All, I'm trying to define an Input control for my report. my report sql includes a parameter like this: ...where tblads.deal_no $P!{mydeal} I've defined mydeal as a string when I run this is IReport I enter the Parameter value I enter at run time for mydeal is : LIKE 'G%' this works in Ireport return all rows where deal_no starts with the letter G Okay, so now I want to run the report on JasperSever, but need to create the Input control to handle this parameter. I defined the mydeal input control as a Single select List of Values (radio) The each list itemis label : G Deals value: LIKE 'G%' label : non G Deals value: NOT LIKE 'G%' Unfortunately this returns an SQL error when run on jasper server, and I though it has something to do with the quotes. So I tried value: " LIKE 'G%' " and value: LIKE "G%" and value: LIKE 'G%' and other the variations of the above.. but still I get a syntax error. AM LOST. Can someome please help me?

hi all, I need to retrieve a copy of an uploaded jrxml file from jasperserver. my local copies were deleted. but I cannot find the physical location of the jrxml files stored in jasperserver? I can't edit(in order to copy) the file in jasperserver either. any advices appreciated.

I found commons-lang-2.1.jar file and tried this: (note I replaced backslashes with forward slashes below - just for display purposes in this forum) javac -classpath "C:/Program Files/jasperserver-3.0/scripts/lib" -d C:/java-util MyUtils.java but unfortunately it stil returns error: MyUtils.java:4: package org.apache.commons.lang.time does not exist import org.apache.commons.lang.time.DateUtils; ^ MyUtils.java:9: cannot find symbol symbol : variable DateUtils location: class MyUtils date = DateUtils.truncate(date, Calendar.DATE); ^ 2 errors

this forum removes backslashes, so with all the paths in the post above, it doesn't read too well.

Hi again Lucian, Sorry to ask, but having scoured the forums, and read the scriptlet chapters in the manuals, am still confused and just want to confirm the simple steps needed to get this method working. 1. I copied your code into a file called MyUtils.java and placed it in it's own directory C:utils 2. Since my local jasperserver has javac, I thought I'd just use this. So, from the command line, I changed directory to the ..jasperserver-3.0javabin and tried the compile command : javac C:utils MyUtils.java this compile failed with : ----- MyUtils.java:4: package org.apache.commons.lang.time does not exist import org.apache.commons.lang.time.DateUtils; ^ MyUtils.java:9: cannot find symbol symbol : variable DateUtils location: class MyUtils date = DateUtils.truncate(date, Calendar.DATE); ^ 2 errors ------ Okay, I gathered that I need to include the classpath for org.apache.commons.lang.time in the compile args. Next problem, is trying to physcally locate the jar in which org.apache.commons.lang.time resides. There is no obvious directory or file name in my apache-tomcat installation that I can associate with org.apache.commons.lang.time. So I tried this javac -classpath C:Program Filesjasperserver-3.0apache-tomcatcommonlib -d C:java-util MyUtils.java this failed due to the space in my path name, in - 'Program Files' to I put double quotes around the full classpath I also tried replacing the space with %20 (just in case) I also tried another apache path javac -classpath "C:Program Filesjasperserver-3.0apache-tomcatbin" -d C:java-util MyUtils.java but all failed with same original error. So how do I include this class? Assuming that I get this to compile, by what I've read, it then generates a subdirectory with a .class file. How do I then 'put' that into a .jar file? Once I have a .jar file, should I move it into the ..apache-tomcatcommonclasses directory ? would that be the normal logical location for these custom classes? Once I have a compiled jar, I assume all I have to do is include it in the classpath of the report and call it as per your description. A final question - this report is going to be run a remote Mac Osx jasperserver. So, can I just upload the .jar to the jaspersever, or do I need to recompile the .java there too because of the different classpath arg used in the local javac compile? I know I'll need to change the classpath the jrxml file before uploading it to the Mac. Sorry for the long winded response, being a first timer I could not find any simple step-by-step guide to doing this. thanks for any help

Hi Lucian, once again thanks for the support. regarding the method for getting date, this is my first java attempt, so please bare with me: to test out your method/class in IReports, firstly I copied your code into a .jar file on my local directory. then, via menu option Options/ClassPath added the jar file and saved the classpath. I then edited my date parameter, adding default value expression : new MyUtils.getLastDayOfWeek(java.util.Calendar.WEDNESDAY) however, attempting to run the report returns error: it.businesslogic.ireport.gui.logpane.ProblemItem@15aba3a MyUtils.getLastDayOfWeek cannot be resolved to a type Line 27, Column 28 /jasperReport/parameter[1]/defaultValueExpression[1] exluding 'new' also results in error: it.businesslogic.ireport.gui.logpane.ProblemItem@10db6ae MyUtils cannot be resolved Line 27, Column 28 /jasperReport/parameter[1]/defaultValueExpression[1]

Hi All, After searching the forums, I can't find an answer that works for me, perhaps you could help? 1. setting default selected items for multi-select parameter. I know the input control is supposed to use the parameter default, but this does not work : <parameter name="Pay_Opt" isForPrompting="true" class="java.util.Collection"> <defaultValueExpression > <![CDATA[java.util.Arrays.asList(new java.lang.Integer[]{new java.lang.Integer(0),new java.lang.Integer(1),new java.lang.Integer(2),new java.lang.Integer(3),new java.lang.Integer(3)})]]> </defaultValueExpression> </parameter> Not sure why the input control, which I've defined with 0,1,2,3,4 as values (labels are words), is not using the above default. 2. I also have a separate input date parameter that I need the default value always to be date of last wednesday. Any pointers on how do build this expression would be greatly appreciated. thanks for any help

Hi again, just an update, after retest with final v3.0, the error no longer occurs. thanks a lot for the help today.

Hi Lucian, thanks for that, will install and test it asap. an install question - I know there is an upgrade script going from v2 to v3, but is upgrading from v3 rc1 possible? or should I just do a complete re-install?

Hi Lucian, the only 3.0 version I see is 3.0.RC1 at this link http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243&release_id=593993 these are the ones I installed (ie: .exe on windows, and .zip on Mac) if there is another/ later version please direct me to it and I'll happily test it. thanks,

sorry, just to clarify, it's the JasperServer on the Mac that is returning this error, my local JasperServer on WinXp (which is the same version but I used the Windows installer package), works fine.