kingsnet

It seems a simple enough thing to do but I've tried everything and I can't figure it out. All I need to do is count the number of times a boolean is true over a group and show it in a group footer. Any ideas? i get 'incompatible operand types boolean Boolean' but the expression validates: $F{MyField}== true ? new java.lang.Integer(1): new java.lang.Integer(0) MyField is a boolean. Hope someone can help, I'm getting desperate!

Hi there. I'm trying to create a user friendly report server for our staff based on the JasperServer 2.1 windows install. Only thing is I've found that if the report data source is ODBC (Access) then Multi-select query based input controls cause an SQL 'source not recognised' error. The same setup will run perfectly if the source is MySQL with the same table names. I just can't get query based input to work with MS Access. Any ideas? thanks PS I'm using the $X{ IN,field,parameter} method in my criteria. If there's another way for a non-developer like myself I'd love to hear it. Post edited by: kingsnet, at: 2008/06/26 23:03

Only thing is I'm not really a java developer (or a developer for that matter!). I've been able to get a working report server more by brute force and persistence shall we say. Is there REALLY no way to solve this? it seems so basic a requirement. How would I go about creating a new options form that lists the items in the way I want them displayed? I'd rather not delete them all and add them again in the order I want..! Can anyone help?

Ho do I change the display order of items in Report Options? I'm using iReport 2.05 and Jasperserver 2.1. I can change the parameter order in iReport but that has no effect. The display order seems to follow the order in which input controls were added to the repository? Hope someone can help

Thanks!. After Gaby38's reply I tried just passing the date as a string in the form 2008-04-07 and hey presto it worked!. I'm guessing that if the parameter is a date instead of a string, you have to match your locale to get it accepted then re-cast to a string in the form Y-m-d to get the sql to work? Thanks again for the amazingly quick responses here.

I'm directly accessing a report produced with ireports 2.05. I'm running jasperserver 2.1. My problem is I can only get the report to run by using the parameter form. If I try to run the same report via the url, it comes up blank: http://ws02:8080/jasperserver/flow.html?_flowId=viewReportFlow&_eventId_selectReport=&reportUnit=/reports/Event_Management_Reports&decorate=no&output=pdf&date_banked=07-04-2008 can anyone help please? thanks

I have a multi-select on a form that returns an SQL syntax error [fred blogs],[harry smith] for the values selected. Where do the brackets come from? I'm using the latest jasperserver recently downloaded. I'm using WHERE myfield in $P!{Parameter}. I also tried "$P!{Parameter}" and '$P!{Parameter}'. iReports and Jasperserver give the same error. My parameter is a collection. How do I get a list of values from a form? I tried $X but I get field $X not recognised so I went back to $P! as it's comes closest to getting me a result. Can anyone help please?

As it was my mistake in the URL I'm not sure if a bug report is appropriate, unless you consider unfriendly handling of the error a bug?

Ouch!! I think I dropped the ball there, the URI was incorrect. I missed out the underscore in cells_mysql! that cost me ages. Thanks ever so much for your assistance, what a relief!. PS - is there a way to handle this basic error more in a more explanatory way?

Ouch!! I think I dropped the ball there, the URI was incorrect. I missed out the underscore in cells_mysql! that cost me ages. Thanks ever so much for your assistance, what a relief!. PS - is there a way to handle this basic error more in a more explanatory way?

oops! double post - ignore Post edited by: kingsnet, at: 2008/01/08 09:21

You are right, it isn't defined. But in all working examples I've seen, the parameter you refer to appears as &_eventId_selectReport=& in the URL - no parameter. In my situation for the MySQL data source I can include &_eventId_selectReport=& and get the error or leave it out and still get the error. So I'm not so sure if that's the problem. Also for the Access data source, I can do the same thing and still get a pdf succesfully. I tried something else out. The error report refers to an actionstate 'checkforparams' in viewReportFlow.xml and seems to imply it can only handle a transition for 'yes' or 'no', but it's being asked to handle 'error' which is not defined. To check this out I added a transition for 'error' to checkforparams and picked another defined action just to see what would happen. Sure enough, it actioned whatever transition I chose!. What I don't know is why the error exists and what it is as the errorpage transition just gives me a blank page. Hope you can help many thanks

Hope someone can help, I'm new to Jasperserver. I used the examples above to directly access a report successfuly, however the report fails with a MySQL source but works perfectly with an Access database source. Here's my URL: http://ws02:8080/jasperserver/flow.html?_flowId=viewReportFlow&_eventId_selectReport&reportUnit=/reports/cellsmysql&decorate=no&output=pdf Here's the 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 can access both reports successfully direct from the repository without error, but I need the url option. Has anyone seen this before? Hope you can help thanks Post edited by: kingsnet, at: 2008/01/06 18:03

Forgive my ignorance, I'm totally new to all this. What changes would I need to add to make it work? I'm still puzzled as to why it would work fine for the Access database but not the MySQL?. Many thanks for offering assistance.

Hi there, I've downloaded the latest jasperserver install for windows and set it up for anonymous access. My intention is to directly access two reports created in ireports via a url.Both reports are the same but the data source is MS Access for one (A), MySQL for the other (B). Here's my URL: http://ws02:8080/jasperserver/flow.html?_flowId=viewReportFlow&_eventId_selectReport=yes&reportUnit=/reports/cellsmysql&decorate=no&output=pdf When I click the link,(A)gets me a PDF but (B) produces an 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']]'. They both work if accessed directly from the repository. Any ideas please? Post edited by: kingsnet, at: 2008/01/05 15:25