ronedog

Anyone know how to disable the cache?

I am having trouble with some input parameters not refreshing the data when it changes in the database it gets pulled from. If I give it some time, or manually clear out the" /jasperserver/org/apache/jsp/WEB_002dINF" directory, then restart jasperserver, The input parameter gets refreshed and the new data shows up. I want to disable the cache complete so the input parameters don't pull from a cache. How can I do this? I'm using 3.7 CE. Thanks.

I've been using jasperserver 3.7 for a few months on tomcat 5.5 I wanted to upgrade to tomcat 6.0.29 but I'm sort of lost as to getting jasperserver to work on my linux box. I copied all the folders and files from "tomcat5.5/webapps/jasperserver" to the new install on "tomcat6/webapps/jasperserver" then I shut down tomcat5.5 and restarted tomcat6, but when I run the jasper reports it doesn't load anything, doesn't even connect to jasperserver. Do I have to run the jasperserver.bin again from scratch, or are there some config files I can just change in the new install? I'm afraid it will overwrite all my database stuff...is there just a way I can copy all the files under "tomcat5.5/webapps/jasperserver" directory where I put everything, into the new tomcat6 webapps/jasperserver directory and have it work? Thanks in advance.

Well, I found where I could remove the "root" word inside the db. if anyone wants to do it this way its in the table called jiresourcefolder

Thanks Ramnik, but when I right click and go to properties, it just brings up a box that summarizes the folder information with an "OK" and "Cancel" button. It doesn't give me the option to change the name anywhere. I'm logged in as jasperadmin. I also tried giving the folder read/write permissions to ROLE_USER to see of that would work, but same result? I can see if I select a subfolder of "root" then I get a text box that allows me to change the name of that folder, but it's the name "root" that I want to be changed. what am I doing wrong? Post Edited by ronedog at 06/23/2010 22:46

Jamie, Thanks. that was it. Do you know how to change the word "root" that is the folder where everything is underneath in the left pane? I would like to change it to says "All Reports" instead of "root" and preferably get this value from a language file. Post Edited by ronedog at 06/23/2010 15:51

well, it sounds like thats what I'm doing, but I'm having the same problem. This is on Windows Vista running 3.7.2 of iReport...do you think there is a problem with this environment? Could there have been something wrong during the installation with Tomcat?

Ok, so are you saying the way I've been creating input controls via iReport is not actually saving them in the repository? Here's how I created them. inside iReport I opened the repository view from the menu "WINDOW -->JasperServer Repository". This opens the folder view on the left hand side in my picture #1 from the 1st post I made. Then I "Right-Click" the repository (root) icon add folder (folder 1), then "Right-Click" the folder 1 and "Add Report Unit", then "Right-Click" the report unit and "ADD Input Control". So is this creating the input control locally and not in the repository? If so, how do I create the input controls in the repository? Thanks.

I'm confused. The way I've added the input controls is just how you described it. I saw your picture and you have all those input controls as options to select. Take a look at my 1st picture and you'll see a list of already created input controls....then take a look at the 2nd picture where I can browse and select input controls, you'll notice that there are no input controls I can choose from, however, I know they exist somewhere because the reports work, and I can see them in the repository? I noticed your input controls are in a "COMMON" directory, am I simply looking in the wrong folders?

Thanks for your reply. I'm getting this in the iReport Designer. I've attached a picture of my screen that will show you where I have "rignt-clicked" and the menu "Link and existing input control" that starts the wizard. The 2nd attachment is where I add the input control, except it gives me an error "<report_name> is not an input control" I don't know of any other way to add an input control...I tried looking around iReport, but couldn't see anywhere else to do this?

Guillaume, I tried setting an input control in the repository for REPORT_LOCALE, and set its value to "fr_FR" (of which I have bundle for), but when the report is ran I still have "en_us" which is being read from my browser and the value does not get changed. Can you show an example of the code you use to assign the REPORT_LOCALE a new value, I would really like the users to be able to change their locale at Report Runtime, rather than at Login. Thanks.

I'm using ireport 3.7.2 and jasperserver 3.7.0. I got the Cascading Input Control feature working now and it works great when there is data for the succeeding controls. However, If I select something in the first parameter control (Which is a multi-select query), the second control (also a multi-select query) then runs a query to return data for the 2nd list. If there are no results to display for the 2nd list I get an error message box that pops up. It's a blank message that just says "ERROR:" and that's it. How can I handle the situation when a 2nd or 3rd cascading parameter won't get populated because there are no results? I don't mind if the control just stays empty, I just don't want the message box poping up. Both the 2nd & 3rd controls are NOT manditory. Thanks for the help.

Thanks Jamie, that did it. One last adjustment, do you know which .css would remove the name of the repository folder the report is under (This shows up as a greyed name under the description)? Thanks. Aaron

I'm not sure if this is supposed to be somewhere else, so my apologies if it is...after I posted this in iReport I realized that it might be more specific to the server's repository, so i decided to post it here. I'm using iReport 3.7.2 and JasperServer 3.7.0. When trying to Link input controls it isn't working. I right-click the Input Control folder, and it brings up a dialog box to allow me to browse the folders in the repository. When I go to the folder for the input control I want to link to it allows me to select the folder, but when I press "Open Resource" I get an error message that says "<name> is not and input control". And nothing gets linked. I would assume that there should be a file of some sort that allows me to choose the actual input control I want to link, but I don't get anything like that, just the folder where the inputs are located, and I can't drill down any further...is this working in these versions? Thanks.

I need to slightly change the display of the list of reports when looking at the repository section. I would like to remove the "Create Date" column and give the report name a little more space. Does anyone know which .jsp I need to update to do this, or if there is another configuration setting I can set? I tried changing ListReports.jsp, and have been poking around the other .jsp's but I'm not finding it. Thanks for any help.

that worked, thanks

Great. Thanks!

Thanks.

I downloaded iReport version 3.7.2 and created a new report and wanted to link the existing Input Controls to some other reports, rather than have to keep retyping the same thing for the new reports. I can see where the option is there, but when I go through the wizard to link the control from an existing report I get a message saying "<report_name> is not an input control", but there are no other options to drill down further in the folder popup and select anything else? I read some other posts where this worked in an earlier version, then it got forgotten about in version 3.0, but got put back down the road. Has it gotten forgotten about again in 3.7.2? If anyone out there is able to do this in 3.7.2, please chime in and let me know and I'll look for some other problems. I downloaded the .exe installer for windows...this is running on windows vista. Thanks.

How can I assign a value to a variable, then use that variable throught the report. For example, I tried: Inside the variable expression I put "$V{cat_id} = SELECT cat_id FROM category WHERE category_name = "bob" But this gives me a syntax error. I want to use the variable $V{cat_id} in the report in the SQL part....or simply throughout parts of the report...Is this even possible? Thanks.

I'm using Web Services to run some reports created in iReport on JasperServer. Is it possible to pass the whole querystring that is located inside the XML? For example, If I add the following string to my call to jasper from php can the report use this query to populate the data? <queryString> <![CDATA[sELECT * FROM table WHERE j=2]]> </queryString> Basically, I'm trying to find a way to dynamically create the SQL for the report, then pass the SQL over to Jasper to run the report...is it even possible? Thanks.

Well, never found out why the samples don't work. But I found another post and their code worked, so I was able to test webservices and no longer need help with this question. Heres the link to the site that helped me: http://sneakybits.blogspot.com/2008/11/php-client-for-jasperserver-via-soap.html

O.k, I found that running it in the Apache webroot works, however, the index.php requires "SOAP/Client.php" but this folder and file are not in the directory. So, I tried to look for it in my php installation, but the only folder is for the Zend Framework and I tried copying the soap folder from there, but then it is trying to redeclare some zend classes....is there a different SOAP folder that was supposed to be included with the JasperServer install?

I would like to look at using some Web Services and want to test the PHP samples to get familiar with it, but I'm having problems getting it to run right. I'm running PHP 5.3.1, SOAP Client and SOAP Server are both enabled in the PHP.INI. and using PEAR 1.9.0, on a Windows vista with JasperServer 3.7 I placed the "Samples" folder under <tomcat installation>/webapps/ directory, then went to http://localhost:8080/samples/php-sample/index.php to run the script and I get the following: -------- getFault()->faultstring; } else { session_start(); session_unset(); session_register("username"); session_register("password"); $HTTP_SESSION_VARS["username"]=$username; $HTTP_SESSION_VARS["password"]=$password; header("location: listReports.php"); exit(); } } ?> Welcome to the JasperServer sample (PHP version)Type in a JasperServer username and password (i.e. jasperadmin/jasperadmin) ------ when I type in the username/pwd credentials index.php just posts to itself and does nothing? What is wrong with my enviroment? I'm pretty sure the "getFault()....bla, bla" section shouldn't be there...looks like the starting "<?php" tag was missing, but when looking at the code, it is not. I also tried putting this into my webserver's root running on Apache 2.0, but I get a bunch of "include" errors from the client.php page. Am I placing the Sample folders in the wrong place? Thanks in advance for any tips.

that was it Ramnik. Thanks!