les_mills

Hey all, Originally posted this in the iReport forum but really could be here as well. Writing it in iReport though. My main report contains a sub-report. This will run for each group and is housed in the detail band. Returning from the sub-report is a variable. It has a home in the parent report and its calculation type is set to 'system' and its reset type is 'report' I display this variable in the detail band. I set its evaluation time to 'band' and everything looks good. I then create a new variable which is the sum of the afore mentioned variable. Its calculation type is 'sum' and its reset type is 'report'. Its sums them up perfectly, except the value from the last detail band. It would seem that it is not available until after band has run. If I add it manually to the total when displaying, its fine. But thats cheating Also, how do I get the sub-report to return a zero value if the sub-report runs with no pages. Thanks P.S. We have been getting some great reports using Ireport and Jasper Server. Fantastic stuff.

Hey all, My main report contains a sub-report. This will run for each group and is housed in the detail band. Returning from the sub-report is a variable. It has a home in the parent report and its calculation type is set to 'system' and its reset type is 'report' I display this variable in the detail band. I set its evaluation time to 'band' and everything looks good. I then create a new variable which is the sum of the afore mentioned variable. Its calculation type is 'sum' and its reset type is 'report'. Its sums them up perfectly, except the value from the last detail band. It would seem that it is not available until after band has run. If I add it manually to the total when displaying, its fine. But thats cheating :P Also, how do I get the sub-report to return a zero value if the sub-report runs with no pages. Thanks P.S. We have been getting some great reports using Ireport and Jasper Server. Fantastic stuff.

lucianc wrote: This should not be a matter of trial and error, you need to know the repository location of the report unit resource. Thanks lucianc, I hadn't realized you had to reference from the root. I had only tried from the folder I was in. Simple mistake. Glad to get that one out of the way. Can you please clear something else up in relation to this and passing parameters? Is it true that the "Link Parameters" tab of the hyperlink section is not used in this case and that we have to include the parameters in the URI. For example, this is my current URI: "http://<<local-server>>/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/Education/testing_links_report&trainingid=$F{training_trainingid}" If that is the case, how does the new report gain access to parameter from the URI. It seems a little strange that Jasper Server would not work with a tag in a report that was written for the purpose. I have defined a parameter in the drill-to report as trainingid. Cheers, Nick

Hey Lucianc, I have checked what I have in the repository and I either get the error as described above, or I get this one: com.jaspersoft.jasperserver.api.JSException: jsexception.null.uri com.jaspersoft.jasperserver.api.JSException: jsexception.null.uri at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:529) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:146) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:130) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:128) at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) I have tried: "http://<<local_server>>/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=testing_links_report" "http://<<local_server>>/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=testing_links.jrxml" "http://<<local_server>>/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=testing_links_report.jasper" as well as with / in front of the address. The resources are all in the same folder. The folder contains: - a file called testing_links that is a jrxml file - a file called testing_links.jrxml that is a jrxml file - a report that is called testing_links_report So I am pretty sure that what I am trying to point at is there. Thanks for your help so far. Any suggestions for what to try next?

Hi, I have been working on this one for a couple of days left and can't figure it out. Simple case, I have a report and I am trying to create a drill down to another report. I have read the forums and it seems quite simple. I am using the "reference" as my hyper-link type. When I run the report hit the link, I get one of two problems. One: Null URI (So this means I have linked it wrong. Not really a big problem) Two: I get this error: org.springframework.webflow.engine.NoMatchingTransitionException: No transition was matched on the event(s) signaled by the [1] action(s) that executed in this action state 'checkForParams' of flow 'viewReportFlow'; transitions must be defined to handle action result outcomes -- possible flow configuration error? Note: the eventIds signaled were: 'array<String>['error']', while the supported set of transitional criteria for this action state is 'array<TransitionCriteria>[[eventId = 'yes'], [eventId = 'no']]' I guess the question is, do I need to link to a jasper sever report, or to a jrxml file resource. This is the xml from the hyper-linked field: <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="Reference" hyperlinkTarget="Blank" > <reportElement x="0" y="0" width="100" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[(($F{program_name}!=null) ? $F{program_name} : $F{training_award_types_description})]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA["http://appserver-prod.lesmills.net.au:8083/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/testing_links_report.jasper"]]></hyperlinkReferenceExpression> </textField> I hope someone can help me on this one. It looks so simple and I know I am doing something stupid, but what is it?

Thanks for the response lucianc. I have restarted the server and the report dates have sorted themselves out. Do you still want a sample or as it has fixed itself is it still worth it? Cheers, Nick

Thanks for the response lucianc. I have restarted the server and the report dates have sorted themselves out. Do you still want a sample or as it has fixed itself is it still worth it? Cheers, Nick

I have a report that I developed in iReport. I have then loaded the report into JasperServer(JS). The report includes a main part and then a sub-report. I supply two dates from JS to the report. My understanding is that they are passed from the JS prompt as a java.util.Date(). Please correct me if I am wrong. When I try to use the parameter in the report, on each iteration (or detail band) the date values are shifting ahead by either 11 hours or 10 hours, depending on whether the date is during daylight savings or not. I read somewhere else on the forum that times may change based on the timezone the data-source is in. So I have removed the timezone from the data-source. The times are still moving. Thanks for any replies.

thanks n0n00b this worked perfectly. Is $X a different type? All I have found in the iReport and JasperReports manuals are $F, $V and $P. Do you know anywhere that has more information about this type? Cheers

I set up a control on a report in Jasper Server and that returns a set of values. The closest that you can use in iReport for parameters is a Collection. I then need to use those values in the parameter in the sql query. So, the example is: Jasper Reports gives a list of customer types. - this is stored as a set Passed to iReport and I try to save it as a collection Passing it to query as: select * from customer where cust_typeid in ($P{Customer_Type}) This produces the compilation error: it.businesslogic.ireport.gui.logpane.ProblemItem@efb588 Parameter type not supported in query : Customer_Type class java.util.Collection /jasperReport/queryString[1] How do I access the values from the set supplied by Jasper Server, in iReport when I only have a collection as a parameter type, and how to get those values out of the collection for the sql query. Cheers, Nick