tdi120

Hi, first thing that pops is if you added the parameter as a multi select query in jasper server. Did you name the local parameter exactly the same? When sending the parameters from report to subreport, the names have to be identical (subreport param to main report param) Resources have to be defined in Jasper Server (parameters and subreport) If all these have been done, it will work. I have provided a detailed description over here: http://alexandru-ersenie.com/2012/06/22/ireport-jasper-reports-working-with-subreports-and-collections-in-jasper-reports/ All good things come to those who wait qants.wordpress.com

Hi, like i posted a couple of days ago in this topic (http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=69220&topid=69697), it seems that i am missing a file in the dwr.jar package. Can somebody please check their server installation, dwr.jar package, and see if this file is there? I cannot proceed further with the cascading params without this file. Thank you for your help Alex All good things come to those who wait qants.wordpress.com Code: <script type="text/javascript" src="dwr/interface/RemoteCascadeDirector.js"> </script> <script type="text/javascript" src="dwr/engine.js"> </script> <script type="text/javascript" src="dwr/util.js"> </script>

Hi Sherman, getting your message today made me try it once more before the week-end I am pretty sure i know the cause of the problem now All patched files are in place, double checked and triple checked. The problem still resides in calling the RemoteCascadeDirector.js, which should be part of the dwr.jar package. Well, it is not. This is the output of my report (code1). As you can see, the RemoteCascadeDirector is being refered from this location. When checking the contents of the dwr package, while engine and util.js are in, RemoteCascadeDirector.js is missing. I redownloaded the latest patch, just to make sure. Still, the file is not there. Now, as i see it , this is the source of my problems. But then...how did it work for other people? Or isn't this the problem? Thanks for trying to solve this with me. Looking forward to finding a solution Cheers, Alex All good things come to those who wait qants.wordpress.com Code: <script type="text/javascript" src="dwr/interface/RemoteCascadeDirector.js"> </script> <script type="text/javascript" src="dwr/engine.js"> </script> <script type="text/javascript" src="dwr/util.js"> </script>

Hi Sherman, firefox was the first browser to try with. It did not work, nor returned any error message. So i switched to IE supposing a Java Script error (which was the case) I have double checked the installation, and once again this morning. As soon as i copy the three scripts over (ajax,cascade,view-report), the error message shows up. I am running JasperServer 3.5.0 Release, on a Glassfish 2.1 server. Any other ideas ? Seems that i am the only one with this problem arround :( Thanks Alex All good things come to those who wait qants.wordpress.com

Hi all, i have been trying to patch the 3.5.0 installation of my JasperServer community edition, in order to use the cascading input controls. The documentation is very straightforward, thank you for putting the effort into it. Unfortunately, i cannot get it running, and there is nothing on the forum regarding my problem. After creating the report, parameters, etc., when running the report, i get the following javascript error reported in IE: 'dwr' is undefined at line 195 of cascade.js 'RemoteCascadeDirector' is undefined at line 105 of cascade.js I can see that FillParams.jsp, ReportTopParametersForm.jsp and ViewReport.jsp all have a reference to dwr/interface/RemoteCascadeDirector.js The applicationcontext-cascade.xml also points to <dwr:remote javascript="RemoteCascadeDirector"> Yet, i cannot find the js file in my jasperserver installation. Running out of ideas... Can anybody help? Or do i have to upgrade to 3.7.0 (not an option right now) Thank you, Akex All good things come to those who wait qants.wordpress.com

hi bidur, you should be able to use multiple querys by using multiple datasets in your report. In order to do that, open the report inspector, select the top node, right click, and choose "add dataset" Each query that you run in a dataset will return some fields. My recommandation would be to use "as" in your querys, to make sure you have distinct fieldnames in the report. Imagine you have three datasets for your three querys. You can then use the fields that these querys return as values in your report Is that what u need? Can i help u further? Cheers, Alex All good things come to those who wait qants.wordpress.com

i do not get ur point exactly. Would u like the sql querys for that, the way to integrate the sql querys for that, or alltogether? are a,b,c three different reports or three different datasets in one report? All good things come to those who wait qants.wordpress.com

yays...never looked inthere :)multiaxis is wonderful :D one piece of advise for everybody: do not try using a multiaxis chart developed in IReport 3.6 with JasperServer 3.5 It just won't work! Thanks Giulio All good things come to those who wait qants.wordpress.com

Hi Neha, you have to use expressions: $X{IN,testrun_id,run_id} - that kind of means ...where testrun_id in (values of your run_id collection) I have covered this subject, and more in this thread: jasperforge.org/plugins/espforum/view.php All good things come to those who wait qants.wordpress.com

After searching a bit on the forum, and upgrading from 3.5.0 to 3.6.1, i give up. I cannot create a multiaxes chart, and i cannot find the reason why that happens. after choosing "Multiselect chart" i am prompted to choose my axis chart. Yet, after choosing it, i cannot work on the newly created chart (again, the right click menu gives me the option of selecting an axis chart) Whatever i do, it seems it does not take the option that i have selected. Anybody else with this problem? Or anybody with a solution ? Thanks Alex All good things come to those who wait qants.wordpress.com

You tried the right function, the question is where. Try converting your date directly in the sql query, that is if the date comes from a database. If yes, use it like this: DATE_FORMAT(DATE_ADD('1970-01-01 00:00:00' ,INTERVAL ts*1000 MICROSECOND),'%H:%i:%s') This will convert your timestamp into a nice, readable form, which displays hour: minute: second. Is this what u needed? Alex All good things come to those who wait qants.wordpress.com

Because it is the value of the object you are using in the variable. that means, if you use a string, you'd have to put it like this: String.valueOf("mystring") and if your variable is of type integer: Integer.valueOf(23) Alex All good things come to those who wait qants.wordpress.com

Just remember that IReport considers the values you put as objects, and not as primitives. That is why you would have to put your String value into quotes like this: "mystring" and when using an integer, you would have to define the value as java expects it: new Integer(24) and when using an array list : new ArrayList(Arrays.asList(new Long[] {new Long(22), new Long(33)})); and so on Think that everything inside IReport is java. Objects, methods etc. Hope this helps Alexandru Ersenie All good things come to those who wait qants.wordpress.com

exactly, i mean the parameter name. Forget mentioning "label" :) All good things come to those who wait qants.wordpress.com

I will try to help on that. My way of doing things is the "raw style". Whenever i add a field in my query, i will ALWAYS add it manually to my report field set. What you really have to take care of, is that the type of the field that you use in your query, matches the type you define in the report. But that is just a hint, your error is related to the nonexistence of that field. So try doing the first step, as i do, save your report, and preview it again. I hope i got that right...Let me know if not. All good things come to those who wait qants.wordpress.com