jvway

So, after going round and round with Java settings and all kinds of ridiculousness I decided to try the Eclipse plugin route for JasperSoft Studio. So far this is working great. I'm using Kubuntu 13.10 and whenever I tried to run Studio 5.5 standalone I would get java errors with no startup or it would run a little while and then crash. I tried lot's of fixes but then installed Studio through the Eclipse marketplace. This along with the Toad Database manager plugin has been a terrific experience. I've only worked on a couple of reports so far and may add more later but I had no crashes and I think it works faster than iReport. Plus you get more of the full Eclipse experience. BTW: this is Eclipse Keplar and jdk1.7. Just an FYI that will hopefully help someone else not spend time pulling their hair out. Jerry

Turns out it was the security settings that were implemented in JasperServer 4.5 http://community.jaspersoft.com/wiki/jaspersoft-450-security-changes-and-configuration#Editing_Input_Validation_Rules

Hi, I'm actually battling this whole calling a MYSQL stored procedure thing. I see suggestions to make a JNDI service that then calls the MySQL db but I'm having a hard time finding exactly how to create the JNDI service. In terms of the MySQL SP it does only accept input parameters and returns a sql query. I've also tried using $P! for string parameters the others are dates. It works fine in iReport but when run agains the jasper server (v4.7) I get back the wonderfully cryptic "there's a problem contact your administrator" I'd love to but I'm the administrator :). Attached is the jrxml Any ideas? Thanks, Jerry

Look into separate data sets. You can bind subreports to individual datasets that can then even have their own connection strings. Right click on your report name and it's a choice there. They are very handy devices.

Interesting. Thanks for the info.

Look into building seperate datasets. In the Report Inspector right click on the name of the report. Then you drop the crosstabs into the summary section. Resize to fit. Works great.

So, I guess my question comes down to, how do I pass a collection as a parameter to a subreport. I think that's what's missing in terms of the index out of range error. It's getting nothing for the IN statement.

Lucian, So your comment that OpptTypeSelect being in the IN statement did make the report funciton but it is not respecting the parameter, so my subreport isn't filtering the way I would expect. I've got some more trouble shooting options but thought I'd pass this on.

I notice near the end of the error output there is this but I'm not sure what it's referring to: Caused by: java.sql.SQLException: Parameter index out of range (6 > number of parameters, which is 5). I mean I guess it's saying I'm only sending it 5 parameters and it's expecting 6. But all parameters are filled with values since the main report runs fine without the subreport. Hm, I may change tack here and try storing the parameters in fields. That's what I've done in the past and seems to work. Just seems like an unnecessary step.

I've only ever been able to get crosstabs to work in the Summary tab. Try it there. I've built dashboards using several datasets and dropping crosstabs into the summary section.

Yeah, unless they are number types you will only be presented with the option to count. If the fields are number type then when you drag the field over iReport will give you the option of sum in the drop down.

I see what you're saying about the $P but in that context it is the subreport and I'm trying to retrieve the parameter value that was entered into the main report. Not sure how else to retrieve those values. In past subreports I think I've used the field data from the main report but this parameter data isn't saved in any fields on the report. I suppose could make them hidden fields if I need to use it that way. Thanks for the response.

I wish I had more time to really spell this out but I think I can give you pointers to look in the right direction. The parameter is of class Collection with a default value of %. My report query has this: WHERE $X{IN, vw_TimeTracker_Oppt.`OppType`, OpptTypeSelect}Then on the jasperserver I make two controls, one is of type query that defines the holds your actual database query: For example there's this one that shows me all but a few that I don't want to have in a selection. SELECT DISTINCT opportunity_type FROM sugarcrm_prod.`opportunities` WHERE NOT ISNull(opportunity_type) AND opportunity_type NOT IN('Existing Business','New Business','Program','Series','Single') ORDER BY opportunity_type Then you create another control where the type is something like Multi-select query (check box or radio button) then select the query control for the query resource. On the value and visible columns I select the opportunity type from the above query. So, I think that adds info on how to present end users with a choice as well as how to limit your return values. I guess I did have time to explain it :) Jerry

Nope I was wrong. I guess I didn't refresh the data. After closing iReport and retrying the report I get the same problem as above. Still need help on why this isn't working when trying to pass prompted paramters to a subreport. Thanks, Jerry

Oh, looks like it was because I hadn't compiled the subreport on its own yet. I usually do that. I just got cocky this time. whoops.

Hi all, (iReport 4.8) I'm trying to pass prompted parameters to a subreport but they don't seem to be getting there. These are parameters that I'm prompting for when running the main report. I have them defind in the parameter map in the subreport properties on the main report. I then have these same parameters defined inside the subreport and in the subreports query. But when I run the main report iReport errors out and shows me ? marks in the place of the parameters in the iReport output window. So it's like the parameters aren't getting passed to the subreport. Error filling print... net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT Sum(vw_TimeTracker_Oppt.`OpptTotal`) AS SumOpptTotal, Sum(vw_TimeTracker_Oppt.`ProjGross`) AS SumProjGross, Sum(vw_TimeTracker_Oppt.`ProjForecast`) AS ProjForecast, Sum(vw_TimeTracker_Oppt.`CombinedTime`) AS SumCombinedTime, Sum(vw_TimeTracker_Oppt.`RateCalc`) AS SumRateCalc FROM `vw_TimeTracker_Oppt` vw_TimeTracker_Oppt WHERE Left(vw_TimeTracker_Oppt.`SolutionName`, 4) = ? AND $X{IN, vw_TimeTracker_Oppt.`OppType`, ?} AND (vw_TimeTracker_Oppt.`EndDate` >= ? AND vw_TimeTracker_Oppt.`EndDate` <= ?) AND (vw_TimeTracker_Oppt.`Posted` >= ? AND vw_TimeTracker_Oppt.`Posted` <= ?) Attached are the two files. Thanks in advance, Jerry

Hi all, In iReport 4.8 I was creating a new parameter and noticed the DateRange type in the drop down. Googling doesn't showa definition for this and how to use it. I do tons of date range filtering and this seems promising. Can anyone point me to how to use this? Thanks, Jerry

Thanks Kris, It was the standard. I 'know' I entered that in there before but I must have been mistyping something. In now.

Hi, I've been off iReport for a while and I've recently rebuilt my machine. Unfortunately I don't remember the Repository Server settings I used in iReport for connecting to my Jasper server. I've tried many combinations of the standard stuff. The admin who initially set this up often did things in an unconventional manner. Does anyone have a way I can find what the URL is to connect iReport v4.7.0 to a JasperServer community version repository for publishing reports? It's on a Centos Linux box and I do have root access. Hoping it's in some configuration file. Thanks, Jerry

I asked this in a more convulted topic earlier that got no response so I'm just going to ask again. Last time I was on iReport I used 4.0.1 and when uploading a report to Jasperserver, if there were subreports it would prompt to see if you wanted to include them. Then it configured everything automatically to load them. This doesn't happen in 4.5.1, at least not on my install. Is this now the default behavior and I have to manually update the Main report? I'm using: Product Version: Jaspersoft iReport Designer 4.5.1 Java: 1.6.0_24; OpenJDK 64-Bit Server VM 20.0-b12 System: Linux version 3.2.5-3.fc16.x86_64 running on amd64; UTF-8; en_US (ireport) Thoughts? I had high hopes for the JasperStudio but no one pays attention to the forum which is tough for such a new product. Thanks, Jerry

So, unfortunately I've been out of the iReport/jasperserver game for a while. I've been getting a new server up to run jasperserver and finally got that all working. I'm using iReport 4.5.0 and when creating a new report on jasperserver it no longer asks me about subreports. So, when I try to run the report on the jasper server it has my local machine path for the subreport. This is even though the sup report parameter says subreport dir and not an absolute path. I'm not sure of the last version of iReport I used but it seems like it used to ask you about the subreports and whether you wanted to include them. I guess there are two questions, is that feature gone and if so how to you go about telling iReport/Jasperserver about the subreports. Additionally, the error says it's looking for the .jasper file for the subreport and that it can't find it on my local machine. Why in the world is it looking for it there. Did something change in the iReport world where I need to upload a .jasper file as well. Thanks, Jerry Post Edited by jvway at 03/08/2012 01:50

This is kind of an old post but I'll reply anyway. You may be looking for iReport plugin and what you really need is a netbeans plugin. Netbeans is what iReport is built on.

Hi, so I'm trying, in Studio 1.0.7 to connect to a jasper server repository. I can connect to the same repository using the latest iReport so I'm pretty sure that it's working and configured correctly. I'm running the latest jasper reports server on Windows 2008 R2 using the bundled install. The I'm running the full install of JasperStudio 1.0.7 on Fedora 16. Could there be something wrong with the client setup? Any help greatly appreciated. Moving back to iReport until I can see that this forum gets some attention. I triple checked the passwords and URL but I get the following error: java.lang.NoClassDefFoundError: org/apache/axis/EngineConfiguration at com.jaspersoft.studio.server.WSClientHelper.checkConnection(Unknown Source) at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Caused by: java.lang.ClassNotFoundException: org.apache.axis.EngineConfiguration at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:513) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) ... 3 more

I've got all my files source controlled in one place. How can I change the workspace in Studio. it seems locked down compared to Eclipse proper. This MyReports things seems limiting. THanks, Jerry

Thanks, I had tried that but turned out I had extracted jasper studio to a ntfs file systems so I couldn't change perms. Moved it to another partition and that worked.