SeanDay

We have run the report both in iReports and on Jasper Server and both are slow, we think it may to be linked to the fact the query uses a database link. As we only wanted to provide the users with an option of one or all in the parameter first we re-wrote the likes from: WHERE value LIKE param to: WHERE (param = '%' OR value = param) However, although this appeared to fix the problem on iReports when we uploaded to Jasper Server the query started running very slow again. I ran a trace on the Oracle sessions and the issue appears to be related to the database links (specifically the "SQL*Net message to dblink" and "SQL*Net message from dblink" events. When the query is run in SQL Plus/Toad the session had 834 waits a total of 0.55 seconds. When run in iReports/Jasper the session had 1556893 waits a total of 508.29 seconds... We then created a view in the database that looked at the database link and put this view into the iReport query and the query now appears to be fine on both iReports and Jasper Server.. Never really got to the bottom of what was happening but we have a solution that works. Thanks, Sean

Thanks for the suggestion, I was running the query in both Toad and SQL Plus. I have downloaded SQuirreL and using the same jdbc driver as I use for iReport the query works and returns the data in less than 2 seconds. Unfortunately this looks like an iReport/Jasper Report issue. One thing I noticed when capturing the bind variables in Oracle was that iReport appeared to run the query twice (once using the default values setup on the parameters then a second time using the values I typed in). I cannot see what else is going on in the DB though as the query passed to Oracle looks the same the execution plan is the same and bind variables look OK. I removed the default values from the parameters and the query only runs once but still takes about 8 minutes.. This is very odd behaviour but I have seen it before with another iReport we just removed one of the like clauses (making it an equal) and the query was OK. Fortunately it did not require a like in that case. At least I have discovered SQuirreL which looks pretty impressive. Sean

I have an odd performance problem with an iReport, when I run the query directly on Oracle in sql the results are returned in < 1 second. When I run it in iReports it takes about 8 minutes.. I have found that if I remove one of the LIKE clauses from the SQL below (making it an equals) then the iReport runs in a couple of seconds. It does not appear to matter which LIKE I remove. Has anyone seen anything similar before? I have run out of ideas as to what may be causing this.. Thanks, Sean Code:SELECT DISTINCT stu.stu_code, stu.stu_fnm1, stu.stu_surn, stu.stu_cad1 ||' '|| stu.stu_cad2 ||' '|| stu.stu_cad4 CONTACT_ADDRESS, stu.stu_capc, awf.dwh_admin_pwy_jn subject_code, pwy.pwy_name, awf.attendance_mode, awf.enrolment_status, decode(substr(awf.fee_status,1,1),'H','Home','O','Overseas','E','European', substr(awf.fee_status,1,1)) fee_status, amsl.description, amsl.study_location_key FROM attnd_mon_students mon, attendance_monitor_wkly_fact awf, attnd_mon_study_location amsl, ins_stu@delta_link.uel.ac.uk stu, ins_pwy@delta_link.uel.ac.uk pwy WHERE EXISTS (SELECT student_code FROM attnd_rep_wkly_3non_attnd awn WHERE awn.student_code = awf.student_code) AND awf.xtrct_wk_dt = (SELECT MAX(xtrct_wk_dt) from attendance_monitor_wkly_fact) AND (mon.dwh_admin_pwy_jn like $P{PATHWAY_CODE_P}) AND (awf.attendance_mode LIKE $P{MODE_P}) AND awf.academic_year = $P{ACADEMIC_YEAR_P} AND awf.school_code LIKE $P{SCHOOL_P} AND awf.occurrence_code LIKE $P{OCCURRENCE_P} AND amsl.study_location_key LIKE $P{STUDY_LOCATION_P} AND SUBSTR(awf.fee_status,1,1) LIKE $P{FEE_STATUS_P} AND amsl.join_key = awf.study_location_dkey AND awf.dwh_admin_pwy_jn = pwy.pwy_code AND awf.study_yr_dkey LIKE decode($P{BLOCK_P},'%','%',to_char(to_number('1') + 1)) AND stu.stu_code = mon.student_code AND awf.student_code = stu.stu_code ORDER BY 5, 1

Hi, I have openned a call with JasperSoft regarding this and it is a known defect logged as #14317 I will wait to hear from them as to how it can be fixed. Thanks, Sean

Hi Lucian, IE prompts me to Save or Open the file (see attachment) If I click on Open I get a page saying navigation to the webpage was cancelled, if I click on Save I get a message that IE could not download flow.html from the server. Note the odd filename on the screenshot... Thanks, Sean

Forgot to mention, if I remove the j_username and j_password from the URL then enter these when prompted the report opens in PDF OK.. Sean

I am experiencing a similar problem, if I call a report using the following URL: http://js.domain.com:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&reportUnit=/Reports/test&decorate=no&output=html&j_username=username&j_password=password The report works, if I use either pdf, rtf or xls for the output parameter the report fails. Again, this problem only occurs with IE (6 and 7) the reports work fine with Firefox. I am using JS Pro 3.5, this was working fine previously on JS community release 2.1. Did you ever get this fixed? Thanks, Sean

Hi, I have JasperServer 3.5 professional edition setup to import users from LDAP but all users are being imported without an organisation. I do not want to use organisations but was unsure if this might cause problems with the system? If so how can I specify an organisation in my LDAP settings? Thanks, Sean

Hi, Was any progress made with this issue, I am also experiencing this and have lots of nvarchar2 columns that need to be displayed in the domain? Thanks Sean

Hi Samed, Yes, JasperServer can recognise 2 nested reports, I have used this before. I think the problem you have may be related to the file/name of the resource you have uploaded. I notice in the error you have that JasperServer is looking for subreport2.jasper. When working with JasperServer you need to uploade .jrxml files (not .jasper files which are what you use with iReports). You need to modify the subreport1.jrxml file subreport element to use subreport2.jrxml. Hope this helps. Regards Sean

I have tried this in version 2.0.5 of iReports and it still does not work, it looks like the style is evaluated before the value is returned from the sub report.. Is this the way iReports/Jasper Reports are designed to work or am I missing a setting (I always have trouble working out what to put for the evaluation time setting. :unsure: Sean

Hi Samed, Did you get this to work OK with the sum (or the count), I can get the sum to work fine but count is a bit more tricky (although possible). Regards, Sean

Hi Samed, Add a new variable and set: Calculation Type = Sum Variable Class Type = Integer In the variable expression put your cirteria e.g. ($F{YEAR}.equals("1997"))?new Integer(1):new Integer(0) The above example will add 1 for each row in the group where the year = 1997. Add this variable to your report group footer. Sean

Hi, I have a subreport that returns a variable to the parent report. The sub report is in the detail section and I want to use the value returned to style the field/row. I have setup a style and an expression to do this but the style is being applied to the line after the one I want changed. e.g. Style expression set to new Boolean($V{TOTAL_V} > 0) and the row below the one greater than zero is being styled.. I can get this to work using a normal field in the report but it appears the style is being applied before the variable is being evaluated. Is this a bug or a setting problem? Thanks, Sean

Ok, I found it (should have spent a bit more time looking before posting..) The file is js.jdbc.properties in the scriptsconfig directory. Sean