hgfree

I'm no expert, but I have fought with date issues in iReport as well... Maybe try changing the $P{startdate} and $P{enddate} to $P!{startdate} and $P!{enddate}. Good Luck, Chris

Hello, here are some additional formulas for various things. kchaudhry helped me with some of these as well. The java syntax is tricky compared to other languages (in my opinion). Good luck. This forum is very helpful if you dig around. The boolean formulas help to suppress/show objects or control styles. Single String Comparison: new Boolean($F{group_id}.equals("1000016,1000017")) Multi String Comparison: new Boolean($F{group_id}.equals("1000016") || $F{group_id}.equals("1000017")) Number Comparison (if group_id is an Integer): new Boolean( $F{group_id}.intValue() == 1000016 || $F{group_id}.intValue() == 1000017 ) new Boolean( $F{REPORTS_TO}.intValue() == 1 || $F{REPORTS_TO}.intValue() == 2 ) new Boolean( $F{REPORTS_TO}.intValue() < 2 ) new Boolean($F{EMPLOYEE_NAME}.equalsIgnoreCase("Actual Text")) new Boolean($F{EMPLOYEE_NAME}.equalsIgnoreCase("Actual Text") || $F{EMPLOYEE_NAME}.equalsIgnoreCase("Actual Text")) new Boolean( $F{CALC}.doubleValue() < 0 ) new java.util.Date() // defaults to the current date new SimpleDateFormat("yyyy-MM-dd").parse("2008-01-01") // See SimpleDateFormat docs for lots of other possibilities Default Java Date: Date d1 = new Date(aNumberInMilliseconds); Division of variables: create a new F-field and enter this in Text Field Expression Set as java.lang.double new Double($V{SUM_GAQUOTA_1}.doubleValue() == 0 ? 0 : ($V{SUM_GROSSADDS_1}.doubleValue()/$V{SUM_GAQUOTA_1}.doubleValue())) new Integer($F{year}.intValue() == 2008 && $F{status} != null && $F{status}.equals("closed") ? 1 : 0) new Boolean( $F{NETADDS}.doubleValue() >= .9*($F{NAQUOTA}.doubleValue()) && $F{NETADDS}.doubleValue() < $F{NAQUOTA}.doubleValue() && $F{NAQUOTA}.doubleValue() > 0 || $F{NETADDS}.doubleValue() >= 1.1*($F{NAQUOTA}.doubleValue()) && $F{NETADDS}.doubleValue() < $F{NAQUOTA}.doubleValue() && $F{NAQUOTA}.doubleValue() < 0 ) Chris

You are fantastic! Thank you so much! Chris

Hello! Can anyone help me with dividing two variable Totals? I have two variable Totals. Each Total is the sum of a field in the detail band. The Totals appear in a group footer. I would like to divide SUM_Field1 by SUM_Field2. Any help would be greatly appreciated. iReport 3.0.0 pro. Thank You, Chris

We are having a similar issue. No easy way to purge historic instances of reports. Once the historic folder contains about 60+ instances, IE/firefox performance is significantly reduced. We cannot even select reports without locking up IE. I believe Sherman mentioned in another thread that this may be related to security checks being performed by JS. But it is extreme considering the small amount of files it takes to cause such a performance issue. Correction...see post #46080 Speed impact is apparently due to report instance files being "persisted" to the MySQL DB. Sounds like the entire file instance is stored in a DB field. Post Edited by hgfree at 06/23/2009 20:24

OK! Finally got it(time zone setting corrected) after reading every thread I could find regarding time zone...the datasource time. This is best noted in the JasperServer project. Screen shot attached, note the blue section of the datasource set up...LEAVE IT BLANK if your DB already reflects the correct time. Any notes on the Hour:Minute:Second parameter prompt would be much appreciated! Thank You, Chris

Another related note of interest: Using this basic query - select field_id, to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss') as sysdate2, sysdate from source.table where field_id = 123456 I configure the sysdate field to display HH.mm.ss to see if it matches the to_char HH.mm.ss. This yields two different results depending if I run it locally through iReport or run it on JasperServer. The datasource connection is configured the same in both cases. The local result will display the correct time for our time zone (Eastern Time - USA) for both report fields sysdate2 and sysdate. The iReport JS Plugin result will display the correct time for sysdate2, but the sysdate field displays GMT. Also, the JS Plugin will not render in pdf, had to utilize the Jasper viewer...weird? From reviewing other threads, this appears to be related to a server setting somewhere. It is odd that the SQL captures the correct HH.mm.ss using the to_char, but the sysdate that is captured has a different HH.mm.ss.

One other attachment: The format pattern for the field to print: yyyy.MM.dd G 'at' HH:mm:ss z Z

Hello, Using iReport 3.0.0 Running the report locally, not through Jasper Plugin. A datetime parameter has been set up (java.sql.Timestamp) and set to Use as a Prompt. The prompt appears OK. However, the sections for the time entry do not appear to work correctly. There are three sections for time input, which appear to be hours, minutes, and seconds. In the attached screenshot I entered 22:50:30 but the report output shows 22:30:00. The hour is OK, but the minute portion does not appear and the seconds appear where the minutes should appear in the report output. Any ideas on how to correct? Thank You, Chris

Hello Theodan, We are having similar problems. No messages from JS that jobs are not running. The last date ran and next date run are correct until it comes time to run the report. The report is skipped, the last date ran remains the same, the the next date run changes to the correct date for the next run. However...it does not run and JS does not generate a message that the job did not run. Users are emailing us asking what happened to their reports. This is in a production environment utilizing JS commercial. I have read some other posts, but they do not appear to have much useful info. Anyway, just wanted to thank you for your perseverance in this matter. We'll take a look at these settings and hopefully our problem will be corrected as well. Take Care, Chris

Hello Giulio, Thank you for the reply. I checked the flag to patch the file, still getting same error. I'll continue to look around for a fix and post an update if found. Thanks, Chris

1 - org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'jasperReport'. java.lang.Exception: 1 - org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'jasperReport'. at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Hello, I receive the above message when trying to Run Report Unit through JasperServer Pro 3.0.2 Repository in iReport 3.5.0. The report runs OK when executing in iReport Preview. Other Info from About: Java: 1.5.0_06; Java HotSpot Client VM 1.5.0_06-b05 System: Windows XP version 5.1 running on x86; UTF-8; en_US(iReport). I get the following message when trying to run the report through JasperServer Pro. Not sure where to post this as it appears to cross several forums. Any ideas on why this is happening and how to fix? Thank You, Chris Error Trace: com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'jasperReport'.

Hello Lucian, Thank you for the information. We will be downloading the latest version of iReport for testing/development. I will check the Report Unit run functionality. Take Care, Chris

Additional screen shots: iReport prompt and JS Run Report Unit prompt

Hello Anandharaj, Thank you for reviewing. I have attached four screen shots: General, Parameter, Input Control, and Data Type. When I run this report using the iReport execute icon, it prompts for date allowing me to choose a date from a gui calendar. When I run this report using the JS plugin 3.0 Run Report Unit icon, the date prompt is an empty text input drop-down. I will reply again with some additional screen shots showing the parameter prompts. Thank You, Chris