sarahmei

lucianc wrote, in another thread: For dates and datetimes, the values can either use a fixed format (by default "yyyyMMddHHmmss", set via Spring in actionBeans.xml) or the format used for the interactive calendar. If it's not accepting the format you want, you might be able to change the default format in actionBeans.xml. Post edited by: sarahmei, at: 2006/11/20 23:40

This looks like a type issue. Your field is a BigDecimal, and you want to make it a Boolean. You can't cast between those types directly (hence the error). First I'd try to change the type of the field to something more useful. A decimal representation of a field that's always 0 or 1 doesn't make a lot of sense. If it must be a BigDecimal, then I'd try something like $F{RPT_SHOW_PRINTED_BY}.toBigInteger().equals(BigInteger.ONE) which returns a true if the original field is 1, and false if it's anything else. Because of the conversion from decimal to integer, though, you may run into odd errors if the field is slightly off from 0 or 1.

If you just want to run reports from PHP, you can use the URL addressing feature of 1.1.0. (A forum thread on how to do so.) To create reports, input controls, etc., you will indeed have to use the webservices interface. I don't have any PHP examples, but the source for the JI plugin to iReport is released. I think jasperintelligence-ireport-plugin-1.1.0/src/main/java/com/jaspersoft/jasperserver/irplugin/wsclient/WSClient.java is the relevant file.

bhaugland wrote: I need to have security in the JasperIntelligence web application. However I want to pass credentials from another web application to the JasperIntelligence so the user is not forced to log on a second time. One way to do this is to write a filter (implements javax.servlet.filter and org.springframework.beans.factory.InitializingBean) that looks at the incoming request and decides whether or not to proceed. This would work if your credentials are contained within a cookie, for example. We did this coming from a RoR web app.

Great - and the bug's been closed, too. I appreciate the update, Lucian!

jfl wrote: http://jasperforge.org/sf/go/artf1494?nav=1 The last developer comment on that bug, which indicated that it would be fixed in the next release, was made one day before 1.1.0 was released. The bug is still open, though. Can anyone confirm that this is fixed in 1.1.0?

To answer my own question -- I don't actually have a dozen MySQL processes. Instead, I have a dozen linuxthreads that ps *thinks* are separate processes. On other systems, MySQL shows up nicely as a single process. The blog post that enlightened me: http://xaprb.com/blog/2006/07/16/how-we-enabled-threading-in-mysql/ Post edited by: sarahmei, at: 2006/11/14 00:14

I'm in 1.0.1, and I'm using "jasperctl.sh start" to start up JI and MySQL. It works great, except that it spawns 12 mysql processes, and I don't want that many. If I do "jasperctl.sh stop", they all disappear. The pid file only has one number in it while the server is running. I've looked in the script itself and I don't see where it's spawning a dozen processes - it looks like it's only spawning one. Any idea what's going on here? Thanks, Sarah

I had this problem when I used an existing installation of MySQL for the JI database. It wasn't able to save report units (or anything else of substance -- though I could make folders). I worked out eventually that it was some setting in MySQL that needed to be changed. I had installed JI over an existing MySQL installation which evidently had a different set of options. Rather than spending a day diffing the config files, I reinstalled JI and let it install its own MySQL. I didn't get that error afterwards.

I want to change the landing page of the built-in ROLE_USER to listreports.html (the list of completed reports). I edited WEB-INF/jasperserver-servlet.xml. It has a loginController bean with properties "homePageByRole" and "defaultHomePage". I changed it to look like the following: Code: <property name="homePageByRole"> <list> <value>ROLE_ADMINISTRATOR|redirect:/flow.html?_flowId=repoAdminFlow</value> <value>ROLE_USER|redirect:/listreports.html</value> </list> </property> <property name="defaultHomePage"> <value>redirect:/home.html</value> </property> I also changed applicationContext-security.xml to give ROLE_USER access to listreports.html. Trouble is, my users that have only the ROLE_USER role are still landing on flow.html?_flowId=repositoryFlow. Even if I change the defaultHomePage property to listreports.html, they land on the same wrong page. I also tried using flow.html?_flowId=listReportsFlow, instead of listreports.html, but I got the same results. Do you see a step I'm missing here? Thanks!

The web service uses the same users & pwds. iReport uses the webservices interface and lets you log in to the server with any user/pwd you've already set up. Maybe try looking at the iReport code for a working example. The error you're getting looks like you might just be missing something in the authentication filter chain.

Thanks, Lucian, those were the magic five characters I was missing! Here's the final (working) xml snippet: Code: <subreport isUsingCache="true"> <reportElement x="16" y="19" width="524" height="89" key="subreport" stretchType="RelativeToBandHeight" isRemoveLineWhenBlank="true"/> <parametersMapExpression> <![CDATA[$P{REPORT_PARAMETERS_MAP}]]> </parametersMapExpression> <connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression class="java.lang.String"> <![CDATA["repo:/Reports/Subreports/OppSummSR0"]]> </subreportExpression> </subreport> Post edited by: sarahmei, at: 2006/09/12 21:53

Out of curiosity, are all serialized objects Strings? Or is there database structure documentation that I could look at? I had the same idea re: inserting lists of values with a utility program, since that functionality isn't available yet. I was trying to dig through the hibernate xml code, but it just says serialized type, without specifying a java type. (As you can probably tell, I'm not very familiar with hibernate.)

Thanks, Lucien, for the idea! I do set the mandatory flag, but it doesn't take. When I go back to edit a control, the box is always unchecked. I poked around in the database, and the mandatory bit in the InputControl table is never being set (it is always 0). When I set the mandatory bit to 1 through the mysql text interface, the blank line is eliminated and the dropdown box works as expected. So it looks like the mandatory checkbox works only halfway. It displays the current value of the mandatory flag, but you can't update the value. I have verified this behavior on Win IE, and both Mac & Win versions of Firefox. Might be a good fix to get into 1.1. ;)

I've got a report that I made in iReport that has 6 subreports. I uploaded the six subreport files to JasperIntelligence as jrxml files. They are in the repository folder [root]/Reports/Subreports. Now I want to include them in my main report, which is located in [root]/Reports. I edited the subreport references in the main jrxml to look as follows: Code: <subreport isUsingCache="true"> <reportElement x="16" y="19" width="524" height="89" key="subreport" stretchType="RelativeToBandHeight" isRemoveLineWhenBlank="true"/> <parametersMapExpression> <![CDATA[$P{REPORT_PARAMETERS_MAP}]]> </parametersMapExpression> <connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression class="java.lang.String"> <![CDATA["/Reports/Subreports/OppSummSR0"]]> </subreportExpression> </subreport> Then I added the six jrxml files as resources to the report unit. But when I run the main report, I get the "could not load object from location" error. Code:[code] org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@e29336 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@12efe47, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Could not load object from location : /Reports/Subreports/OppSummSR0 So I guess I should be referencing my subreports differently. I'm halfway tempted to just refer to them in the file system, but of course I'd rather keep everything in JI. Any ideas?