sdemills

I have what should be a simple problem but can't seem to solve it. I want a particular user to be able to run all of the reports in a dedicated folder but not edit anything or access any other folder. I have created a UserID/PW for this purpose and granted READ access to the folder in question (which is two branches off of the ROOT) e.g. Reports/HisReports/ When I log in with that UserID then JasperReports displays a welcome message but then says "The user has no access to this page. " and the only option presented is to log out. No part of the tree is exposed. What am I missing please? Kind Regards Steve

Thanks for the tip. I set up the additional file mentioned on your blog and got a different error message - clearly it was now picking up my mail parameters but failing to use them. So I changed the params to use my ISP's SMTP server instead of my Yahoo account and it worked just fine. I've bookmarked your blog.

Importing my report from iReport 3.1.2 fails with an error dialog that simply says NULL. Repeating the import from iReport v2.0.2 it goes through one extra step where it tells me that the server does not have my embedded graphic JPG logo that is in the report and gives me a chance to import that too, after which the import succeeds. Attached: the first graphi shows v2.0.2 requesting the JPG and the second shows the error being reported in v3.1.2. Post Edited by Steve Mills at 12/27/08 18:04

I had great trouble with the previous version (2) of JasperServer trying to get it to use Oracle datasources for my reports. Not so with JasperServer 3.1 - it was really easy to set up and this version is clearly geared towards using different databases as data sources. The look and feel of JasperServer 3.1 is also much improved and looks very professional. If you have not yet tried JasperServer 3.1 then I would definitely recommend it. Kind Regards Steve

The version of iReport supplied with JasperServer 3.1 seems unable to store a report that was built outside of the server into the server. This appears to be v3.1.2. I also have the latest iReport which was downloaded separately to JasperServer 3.1 and that too is unable to store a report that was built outside of the server into the server. This definitely is v3.1.2 I still have installed the version of iReport that came with JasperServer 2 and that one IS able to store reports built outside of the server into the server. This is v2. So by using that version of iReport one can get around this problem. The problem is that the first two mentioned above fail to [a] pick up the datasource and convert it for use within the server, and fail to pick up embedded JPGs and have those copied to the server. So this message is really intended as a BUG Report for the JasperServer 3.1 package as it does not integrate properly with its companion version of iReport. Kind Regards Steve

The documentation says to configure these details in... H:Program Filesjasperserver-3.1apache-tomcatwebappsjasperserverWEB-INFjs.mail.properties Obviously the first part of the path depends on where the installation was done. I created that properties file but JasperServer 3.1 doesn't seem to use it because attempts to email reports all fail and the smpt details given in the log aren't the ones in this file. I also noticed that there is another one of these files (already existing this time) in... H:Program Filesjasperserver-3.1scriptsconfigjs.mail.properties However, JasperServer 3.1 doesn't seem to take any notice of that one either because it fails and the log details are the same - they don't contain SMTP details from either of these files. Does anyone know how to configure the email settings (apart from re-installing of course)? Kind Regards Steve

That solved it. Thank you very much for the tip. I was just on the point of getting my calling Java program to read back the jrxml file and edit the query on the fly. That was a really useful tip and I've written it down for future reference. Kind Regards Steve

I'm a relative beginner with iReport. I've built a report with Parameters and they all work ok apart from the one in the ORDER BY clause which reads ORDER BY $P{pSequence} DESC, and more keys. If I include the parameter in the report body then I can see that it is being set correctly. If I edit its value into the SQL statement instead of using the Parameter substitution above, then I get the right results. However if I use the substitution above then the sequence does not come out as desired. I can't tell yet whether that part of the ORDER BY is being ignored or whether the entire ORDER BY clause is being ignored. No error is reported and the report is generated ok but not in the desired sequence. So given that the substitution is working in the report itself - I see the value printed out - and given that parameters used in the WHERE clause are working fine, why doesn't the parameter in the ORDER BY clause work? Any ideas? Or worked examples where it does work? Kind Regards Steve

It might be to do with quotes? When you do the substitution into the query yourself (i.e. not with a parameter) then did you put quotes around the value? If so then you perhaps need to ensure that the result of the parameter substitution also has quotes around it.

I wish to display my parameters in a meaningful way but also need codified values to get the SQL to work. Here's an example: the parameter passed to the report might say "cpMargin" but I might want it to say "Margin %" in the report title. So I have tried setting a Variable and using it in the report title, like this... (Variable set to) new String($P{pSequence}.equalsIgnoreCase( "cpMargin" ) ? "Margin%" : ($P{pSequence}.equalsIgnoreCase( "cMargin" ) ? "Margin" : ($P{pSequence}.equalsIgnoreCase( "sMinutes" ) ? "Volume" : "Product"))) What this is supposed to do is to choose one of 4 values depending on what the parameter is. This compiles and executes but always shows as "null". How can I make this work. There is a workaround of course: my driving Java program can pass two parameters - one to be displayed and one to be used in the SQL but I'd like to know more about parameters and variables and how to get them to work how I need them to.Kind Regards Steve

Am I correct in thinking the last part should have read avg2.equals(null) ? 0 : avg2

I can answer partly my own question: yes it's easy to add parameters and then populate them from a Java program. What I need to know now is the correct syntax for embedding them into the SQL Query within the iReport designer please.

Am I right in thinking that it is possible to define Report Parameters in iReport and then populate those parameters from a Java program which then subsequently compiles and executes the report? Kind Regards Steve

Did you ever get a reply on this issue? I notice it's a very old issue. I installed JasperServer yesterday and I'm having exactly the same problem - i.e. reports a problem with the listener not starting. I also then added the Tomcat Admin module and that runs up ok, and other Apache web services are working ok too, but not JasperServer. Kind Regards Steve